SQL 2008 just installed

  • I didnt find the option to choose collation during installation or i might have over looked, Now hoe do i change the collation on the server ?

  • there is an option to set the collation during install, you need to ensure you select each tab during the install so things like that are not missed.

    Remember you can have databases with different collations within an instance.

    To change server collation see:

    http://msdn.microsoft.com/en-us/library/ms179254.aspx

    ---------------------------------------------------------------------

  • As u said u just installed ...u can remoe and install again that the better way..

    IF u have any data or changes..take backup of all database and do the above and then restore 🙂

  • As u said u just installed ...u can remoe and install again that the better way..

    IF u have any data or changes..take backup of all database and do the above and then restore [Smile]

    This is good Idea rather than choosing alternatives...

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply