tsql, collation, profiler - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Browse by Tags

TSQL to create a TraceCollector with a default collection set Published 24 September 7 5:45 AM | SSQA.net: 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...

Filed under: sql server, profiler, trace, query, tsql, collation, collecter, collection, msdb