Browse by Tags

TSQL to change collation of database, whats new in SQL 2008 then?
Published 12 March 8 1:24 PM | SSQA.net
Cross post from my BlogCasts site....( read more ) Read More...
TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?
Published 21 December 7 3:34 AM | SSQA.net
Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered'...
FIX: Error message when you run a query that references a column of the XML data type in SQL Server 2005: "The XML data type is damaged"
Published 5 October 7 7:32 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...
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...
Modified KBA - How to transfer a database from one collation to another collation in SQL Server
Published 16 August 7 3:37 PM | SSQA.net
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to transfer a database from one collation to another collation in SQL Server http...
TSQL to generate a script that updates a column on every table in my database. How do I do this?
Published 29 July 7 3:39 AM | SSQA.net
SELECT 'ALTER TABLE ' + sysobjects.name + ' ' + 'ALTER COLUMN ' + syscolumns.name + ' ' + systypes.name + '(' + cast(syscolumns.length as varchar) + ') ' + 'COLLATE ' + syscolumns.collation + '...