If yes, then following the instructions below[ref]Please ensure you test any script taken from my website on a test/development machine, before running on a production server.[/ref], from MSDN (http://msdn.microsoft.com/en-us/library/ms179254.aspx):
- Make sure you have all the information or scripts needed to re-create your user databases and all the objects in them. See my note below
- Export all your data using a tool such as bulk copy
- Drop all the user databases.
- Rebuild the master database specifying the new collation in the SQLCOLLATION property of the setup command. For example:
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI
- Create all the databases and all the objects in them.
- Import all your data.
However, if you detach your databases instead of exporting all the data, you can simply re-attach the databases once the rebuild is complete. I was having problem with an installation of SQL Server, and when I had the server rebuilt, I selected the wrong collation for the server. The database was correct, so I just detached the database before rebuilding the master, and now everything is fine