Daily Archive: March 23, 2012

0

Change SQL Collation

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 this command: Setup /QUIET...

0

Get SQL Collation and Version

SQL Query: SELECT @@version as ‘server version’ Select SERVERPROPERTY(‘COLLATION’) as ‘server collation’