Browse by Tags

All Tags » collation   (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...
TSQL to generate a script that updates a column on every table in my database. How do I do this?
29 July 07 01:39 AM | SQL Master | 2 Comments   
SELECT 'ALTER TABLE ' + sysobjects.name + ' ' + 'ALTER COLUMN ' + syscolumns.name + ' ' + systypes.name + '(' + cast(syscolumns.length as varchar) + ') ' + 'COLLATE ' + syscolumns.collation + ' ' + case when syscolumns.isnullable = 1 then 'NULL' else Read More...