February 2, 2010 at 8:54 am
When I installed the sql server 2008 standard edition, I choose the wrong collation. I can manually change the collation for every database I have built but I wish to have it by default for the complete database as SQL_Latin1_General_CP1_CI_AS.
Any suggestion ?
Thanks for any help!
🙂
February 3, 2010 at 1:38 am
i'm not sure for sql 2008 but for older sql's i simply reinstall as it's relatively painless.
about changing a collation of a database later:
changing the collation of a database doesn't influence objects which are already there. so if you change a collation after installing some product and make new objects after collation change you end up with objects with several collations in one database.
February 3, 2010 at 4:05 am
You can do this at the Server Level but it requirees rebuilding the Master Database & reloading the Databases.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply