Browse by Tags

All Tags » msdb » trace » collection   (RSS)
TSQL to create a TraceCollector with a default collection set
24 September 07 03:45 AM | SQL Master | 2 Comments   
use msdb declare @schedule_uid uniqueidentifier select @schedule_uid=(select schedule_uid from msdb..sysschedules where name=N'CollectorSchedule_Every_15min') declare @collection_set_id int; exec dbo.sp_syscollector_create_collection_set @name = N'SqlTraceDefault', Read More...