Tag Archives: collation

Change SQL Collation

Steps for chaning Collation:

  1. Take backup of Databases and logins.
  2. Detach all databases execpt system databases. (All users databases)
  3. Find the SQL server installation path (Root of the CD)
  4. Run this command:
    Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLServer /SAPWD=Qwerty123 /SQLSYSADMINACCOUNTS=”administrator” /SQLCollation=SQL_Scandinavian_Cp850_CS_AS

/QUIET – Run it as a sillent installation

/action – We are running rebuilddatabase to change the server collation

/Instancename – withs instance do you want to change collation on.

/SAPPW -SA password for this instance

/SQLSYSADMINACCOUNTS – An administration account, normally the run you are running this from. The user should be administrator of the SQL Server

/SQLCollation – withs collation should you change to.