Browse by Tags

All Tags » sql server » collation » tsql   (RSS)
TSQL to change collation of database, whats new in SQL 2008 then?
12 March 08 11:24 AM | SQL Master | 3 Comments   
Cross post from my BlogCasts site. Read More...
TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?
21 December 07 02:34 AM | SQL Master | 2 Comments   
Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered') IsClustered, SERVERPROPERTY('IsFullTextInstalled') Read More...
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...