Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations SSS148 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
Oct 6, 2005
1
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
SQL in Windchill PLM
Replies
0
Views
670
Windchill Creo
Windchill Creo
SteveMeisel
  • Locked
  • Question
Counting of differant values in one column
Replies
0
Views
622
SteveMeisel
SteveMeisel
tammy09
  • Locked
  • Question
SQL query, multiple dates, seprate columns
Replies
0
Views
664
tammy09
tammy09
itatlantic
  • Locked
  • Question
Installing SLQ Server 2000 Enterprise Edition
Replies
1
Views
637
rtmpxr
rtmpxr
jramz
  • Locked
  • Question
Accessing SQL Server Database with MS Access
Replies
0
Views
653
jramz
jramz

Part and Inventory Search

Sponsor

Back
Top Bottom