Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    5

    Unanswered: Enable and disable case sensitivity

    Hi,

    I use a SQL Server 2000.

    Is there a chance to change the case sensitivity option for a running instance of sql server?

    I know, during the install process, i can activate the case sensitivity. But can I change this option on an already installed server (to case sensitiv or back)?

    Thanks

  2. #2
    Join Date
    Feb 2004
    Posts
    4

    Re: Enable and disable case sensitivity

    Yes you can,
    this option is called collation. You can set it diferently as default for each database at the same SQL server. Also it can be set for each collumn in each table separately.

    Marf.

    Originally posted by jenswitte
    Hi,

    I use a SQL Server 2000.

    Is there a chance to change the case sensitivity option for a running instance of sql server?

    I know, during the install process, i can activate the case sensitivity. But can I change this option on an already installed server (to case sensitiv or back)?

    Thanks

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    I think for that you will need to rebuild master .... which is not highly recommended.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  4. #4
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    5

    Re: Enable and disable case sensitivity

    Originally posted by MarF
    Yes you can,
    this option is called collation. You can set it diferently as default for each database at the same SQL server. Also it can be set for each collumn in each table separately.

    Marf.
    Thanks! It worked. I changed the collation of a database from case insensitive to case sensitive and back.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ummmm...huh?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •