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...

Filed under: sql server, blog, table, tsql, collation, changes

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'...

Filed under: sql server, version, edition, license, service pack, tsql, best practice, collation, server property, engine

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...

Filed under: sql server, error, kba, xml, collation, column, data type, damaged

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

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...

Filed under: sql server, database, kba, collation, transfer

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 + '...

Filed under: change, sql server, databases, tables, collation