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 /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.