Setup SQL and choose the collation
Posted on 2007-07-31
I'm after an opinion: In the help or BOL, Microsoft doesn't make any mention of the option of say picking the appropriate Windows collation, and updating other systems which may link to this new server.
For instance, later this year, we are planning to upgrade including new hardware one of our two production SQL Servers. Quite likely some old hardware will be reused to upgrade other servers, and this may include the second SQL server. (Obviously the associated test and development instances will need to be upgraded to SQL 2005 ... )
I am considering the idea of changing the collation of the database and objects. Why is this not discussed in the BOL and help setup? Yes it is likely to be involved, but as a one off - okay two off, practice and then live - it shouldn't be that onerous.