Change SQL Collation
admin Steps for chaning Collation: Take backup of Databases and logins. Detach all databases execpt system databases. (All users databases) Find the SQL server installation path (Root of the CD) Run…
March 23, 2012
Get SQL Collation and Version
SQL Query: SELECT @@version as 'server version' Select SERVERPROPERTY('COLLATION') as 'server collation'