Post reply

Imported Database requires capitilization in queries

  • August 31, 2006 at 7:48 pm

    #62703

    I have a database in MS SQL 2000 that I import monthly from a backup provided by another firm.  When I run queries against it, the table names and field name are case sensitive.  I know this behavior must be the result of a database setting but I don't know which one.  None of my other databases require case sensitive queries.

    Thanks in advance,

    Mary

  • September 1, 2006 at 2:55 am

    #657969

    It sounds like your imported DB came from a server with a different collation, which affects case sensitivity and sort order amongst other things.  Check out BOL on 'collation' and have a look at this:   http://www.databasejournal.com/features/mssql/article.php/1587631 

    Good luck - Cath

  • September 1, 2006 at 9:56 am

    #658077

    Hi Mary,

    It does indeed sound as if collation is your problem. Check this link to an article by Kimberly Tripp:

    http://www.sqlskills.com/blogs/kimberly/Default.aspx#a7b4c9796-66d0-4ed2-b19d-bef6bb1e3e1d

    This also contains an internal link to a script which demonstrates how to change a database collation. It isn't difficult

  • September 4, 2006 at 2:23 am

    #658271

    Hi,

    Check the collation. You can use the following command:

    select serverproperty ('collation')

    This command will give you the collation of your server.

    Now the database that you are getting on your server, you have to set the same collation. Use this command:

    Alter database <database-name> set collate <collation-name-you-found-in-above-command-result>

    Regards

    Pankaj

    Pankaj Khanna
    Database Administrator - SQL Server 2000

    Keep hope to keep you intact...

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

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