To change the collation of the server, we must rebuild the master database.
The following command can do the trick:
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI
You cannot change the collation of a database. You must export, delete the database and import the data in the newly created database.
Default path to run this command: "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap"
Sunday, November 16, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment