Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Failed job Expand / Collapse
Author
Message
Posted Thursday, July 15, 2010 8:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 14, 2012 6:45 AM
Points: 49, Visits: 122
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
Post #953159
Posted Thursday, July 15, 2010 8:30 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, February 21, 2014 7:54 AM
Points: 1,619, Visits: 1,233
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
Post #953181
Posted Thursday, July 15, 2010 9:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 14, 2012 6:45 AM
Points: 49, Visits: 122
Thanks for the info, yes I am using xp_sendmail and then the light went off. Different database. Go figure.
Thanks again
Jim
Post #953231
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse