Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

case-insensitive db in case-sensitive db server -query problems

Status
Not open for further replies.
jonesdoc

jonesdoc

Computer
Joined
Oct 6, 2005
Messages
1
Location
SE
Hi,
I am running a MS SQL 2000 Server. This server is set to be Case Sensitive (a CS collation) but I have attached a database to this server that is (CI)-Case Insensitive. SQL 2000 should support this but any queries /SQL scripts that runs towards the CI database in this server will still fail unless they have proper case... why?
 
Status
Not open for further replies.

Similar threads

Windchill Creo
  • Locked
  • Question Question
SQL in Windchill PLM
Replies
0
Views
779
Windchill Creo
Windchill Creo
SteveMeisel
  • Locked
  • Question Question
Counting of differant values in one column
Replies
0
Views
712
SteveMeisel
SteveMeisel
tammy09
  • Locked
  • Question Question
SQL query, multiple dates, seprate columns
Replies
0
Views
787
tammy09
tammy09
itatlantic
  • Locked
  • Question Question
Installing SLQ Server 2000 Enterprise Edition
Replies
1
Views
764
rtmpxr
rtmpxr
WalkOfShame
  • Locked
  • Question Question
Query part of a field for data found in another table
Replies
1
Views
775
DBITeng
DBITeng

Part and Inventory Search

Sponsor

Back
Top