July 15, 2010 at 8:18 am
I am about to lose my mind. I have a job that is failing on this...
[SQLSTATE 01000] (Message 18014) ODBC error 208 (42S02) Invalid object name...
the table that is referenced is a valid table(yes I doubled checked spelling). What am I missing?
TIA
Jim
July 15, 2010 at 8:30 am
Does your job use xp_sendmail? Is the table a permanent one or a temp table? When referencing the table, try using the 3-part table name ('dbname.dboname.tablename' if static table) or a global temp table name ('tempdb.dboname.##globaltemptablename').
http://www.developmentnow.com/g/113_2004_11_0_0_436170/ODBC-error-208-42S02-Invalid-object-name.htm
_________________________________
seth delconte
http://sqlkeys.com
July 15, 2010 at 9:15 am
Thanks for the info, yes I am using xp_sendmail and then the light went off. Different database. Go figure.
Thanks again
Jim
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply