george sibbald (5/15/2012)
does the object exist on both servers? Is the owner of the object the same on both servers?
As far as I know, the login name on both the servers is the same which is 'tlfuser'. Could it due to the differenence in operating systems or the way security is handled on SQL 2008 and SQL 2005 ?.
It works okay on SQL 2005 but not on SQL 2008.
no, i think the error about invalid object name is the key. it's clearly connecting to some database...but is it the right database?
george sibbald's thoughts are the same as mine.
1. make sure the connection string is the "right" database....if the user conencts to master, for example, isntead of the database, you'd get that kind of error.
if the table is in an odd schema, like tlfuser.Tablename instead of dbo.Tablename, you would get the smae object not found error.
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!