Post reply

Changing a Server from Case Sensitive to Case Insensitive.

  • July 5, 2005 at 2:43 am

    #89933

    Can you change a Server from Case Sensitive to Case Insensitive without having to reinstall the server?

    I am using SQL Server 2000

    Thanks

    Nick

  • July 5, 2005 at 8:06 am

    #570870

    You can use ALTER DATABASE to change the default collation of a database. For a detailed example, see the topics "SQL Server Collation Fundamentals" and "ALTER DATABASE" in SQL Server Books Online.

  • July 6, 2005 at 8:28 am

    #571257

    Agreed, you can alter the a database but not the server default.

    Just make sure you run the command in master!  Otherwise, you get an error message.

    JerseyMo.

  • July 6, 2005 at 9:54 am

    #571337

    just wondering...what if you changed the collation of model?  Would that have any effect (for new databases)?

  • July 6, 2005 at 9:58 am

    #571342

    SQL Server WIDE collation can't be changed with an ALTER statement. It is selected at setup time. You can rebuild master with the rebuildm utility but I would Advice you just reinstall the server

     


    * Noel

  • July 6, 2005 at 10:29 am

    #571380

    But don't forget that changing the servers collation does _not_ change the collation of any already existing database, table or column!

    regards karl

    Best regards
    karl

Viewing 6 posts - 1 through 5 (of 5 total)

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