Tuesday, July 30, 2013

How to change SQL Collation for SQL Server 2008 R2



How to change SQL Collation for SQL Server 2008 R2

"X:\setup.exe" /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SAPWD=<NewStrongPassword> /SQLCOLLATION=SQL_Latin1_General_Cp1256_CS_AS /SQLSYSADMINACCOUNTS="domain\username"

This command will rebuild the master database and all databases will be de-attached.
databases will not be deleted and you can reattach them after installation done.

X: is the path of the SQL source file

No comments:

Post a Comment