Post reply

Case Sensitive Obejcts --

  • December 3, 2009 at 12:32 pm

    #213153

    This is regarding AdventureWorks Database in SQL 2005.

    When i run any select query against any table in AdventureWorks like

    select * from Person.Contact ---- It works fine

    select * from person.Contact -- it fails saying invalid object name.

    are the objects in SQL 2005 case sensitive..where to change the property?

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

  • December 3, 2009 at 12:56 pm

    #1087337

    Both work for me, but then AdventureWorks database on my development server is using a case insensitive collation. It appears that your install of AdventureWorks is using a case sensitive collation. Right click on the AdventureWorks database and select properties. On the General page (the first page) under Maintenacne you see the collation of the database.

  • December 3, 2009 at 2:25 pm

    #1087385

    Thanks Lynn...It says CS (Case sensitive), but its grayed out...how do i change that now?

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

  • December 3, 2009 at 2:54 pm

    #1087396

    Options page. This won't, however, change the collation of character data in any of the tables. Those will still have the case sensitive collation.

    Curious, why the concern? I'm asking as I am one of those few individuals that prefers using case sensitive collations.

  • December 4, 2009 at 8:00 am

    #1087750

    Thanks Lynn..however, I will continue to use CS collation...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

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

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