i created a db backup and created a new db with it.now 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 letter.is 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
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.