SQL: Reinstalled SQL Server 2005, with the wrong collation??

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:


  • 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


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.