SQL Server: Build Versions and Collation basics
SQL Server Build Version http://sqlserverbuilds.blogspot.com.au/ How to determine which version I am running? http://support.microsoft.com/kb/321185 Changing the compatibility http://www.mssqltips.com/sqlservertip/1436/upgrading-sql-server-databases-and-changing-compatibility-levels/ How to Change the Collation Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales. /* Find Collation of SQL Server Database */ SELECT DATABASEPROPERTYEX ( 'AdventureWorks' , 'Collation' ) GO /* Find Collation of SQL Server Database Table Column */ USE AdventureWorks GO SELECT name , collation_name FROM sys.columns WHERE OBJECT_ID IN ( SELECT OBJECT_ID FROM sys.objects WHERE type = 'U' AND name = 'Address' ) AND name = 'City' Changing the server collation is difficult. It will take to foll...