Case Sensitive Obejcts --

  • 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]

  • 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.

  • 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]

  • 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.

  • 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