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