Browse by Tags

SQL Server 2008 Feature Pack, don't forget to install them as well

Published 18 August 8 2:46 AM | SSQA.net

Its over 2 weeks that SQL Server 2008 RTM is released and no doubt in stating that many DBAs might have performed downloads from their MSDN/Technet subscription to install within their environment. Remember feature pack download for SQL Server 2005 couple...

Filed under: sql server, microsoft, download, collection, feature pack

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