troubleshooting Question

sql server case sensitive

Avatar of zolf
zolfFlag for United Arab Emirates asked on
JavaMicrosoft SQL Server 2005
9 Comments2 Solutions258 ViewsLast Modified:
hello there,

i created a db backup and created a new db with when i use the db in my application i get db error.because the column names are capital in the db and in my java code it is small sql server sensitive to capital and small letter.also the query below gives me error Invalid object name 'bookht_user_session'.
UPDATE bookht_user_session SET logoff_time = GETDATE() WHERE session_id = 0

but when i change it to
UPDATE DOM.dbo.bookht_user_session SET logoff_time = GETDATE() WHERE session_id = 0
it works.
but in my old db i dont have these problem.i am using the same code but only the database is local now instead of remote.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros