Post reply

MY SQL SERVER 2005 IS CASE SENSITIVE - DRIVING ME NUTS

  • May 28, 2008 at 9:33 am

    #207762

    My SQL Server 2005 is case sensitive and it's killing me.

    How do I make it case-insensitive?

    PLEASE HELP!!!!!!!!!!:sick:

  • May 28, 2008 at 10:46 am

    #821321

    First, please post in the appropriate forum and not just anywhere. Moved to Admin area.

    Second, servers have a default collaction and sort order, databases can be set differently, as can tables.

    The only way to change sort orders or collations is to drop and recreate the object, AFAIK. That means reinstalling the server, dropping and recreating the database or table.

  • May 28, 2008 at 3:32 pm

    #821485

    Hi Steve,

    I apologize for posting here.

    I will follow the instruction you left for me.

    I appreciate your patience.

Viewing 3 posts - 1 through 2 (of 2 total)

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