SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : collation

SQL Server Standard Edition: List of Knowledge Base Articles (KBA) that are updated

Mon, 17 Aug 2009 06:20:00 GMT

You have seen the list of SQL Server 2008 Enterprise Edition: List of Microsoft Knowledge Base Articles (KBA) updated and now there are few additional KBAs that pertains to SQL Server Standard Edition has been updated recently with new and major modifications...(read more)

TSQL to change collation of database, whats new in SQL 2008 then?

SSQA.net — Wed, 12 Mar 2008 18:24:00 GMT

Cross post from my BlogCasts site....( read more ) Read More......(read more)

TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?

SSQA.net — Fri, 21 Dec 2007 09:34:00 GMT

Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered'...(read more)

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"

SSQA.net — Fri, 05 Oct 2007 12:32:00 GMT

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...(read more)

TSQL to create a TraceCollector with a default collection set

SSQA.net — Mon, 24 Sep 2007 10:45:00 GMT

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...(read more)

Modified KBA - How to transfer a database from one collation to another collation in SQL Server

SSQA.net — Thu, 16 Aug 2007 20:37:00 GMT

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...(read more)

TSQL to generate a script that updates a column on every table in my database. How do I do this?

SSQA.net — Sun, 29 Jul 2007 08:39:00 GMT

SELECT 'ALTER TABLE ' + sysobjects.name + ' ' + 'ALTER COLUMN ' + syscolumns.name + ' ' + systypes.name + '(' + cast(syscolumns.length as varchar) + ') ' + 'COLLATE ' + syscolumns.collation + '...(read more)