Help changing Server Collation. [modified]
-
Hi. We have an issue where we have a (hummingbird doc management) database that has a collation that is different to the SQL server's (2005) collation. In this case the database's collation has to match the server's collation. Changing the collation on the database will be a bit of a nightmare and I was looking changing the server's collation. It is really necessary to rebuild[^] the master database? Could I not just backup/detach all the databases, uninstall SQL, reinstall it with the right collation and then restore/re-attach the databases? What sort of things should I look out for if I do that? Thanks, Nick
Dad always thought laughter was the best medicine, which I guess is why several of us died of tuberculosis. I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it.
modified on Thursday, May 15, 2008 3:37 AM