December 3, 2009 at 12:32 pm
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?
December 3, 2009 at 12:56 pm
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
Thanks Lynn...It says CS (Case sensitive), but its grayed out...how do i change that now?
December 3, 2009 at 2:54 pm
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply