InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 18:21:43 GMT20http://www.sqlservercentral.com/Forums/Topic953159-54-1.aspxThanks for the info, yes I am using xp_sendmail and then the light went off. Different database. Go figure.Thanks againJimThu, 15 Jul 2010 09:15:40 GMTjim.rasmussenhttp://www.sqlservercentral.com/Forums/Topic953159-54-1.aspxDoes 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').[url]http://www.developmentnow.com/g/113_2004_11_0_0_436170/ODBC-error-208-42S02-Invalid-object-name.htm[/url]Thu, 15 Jul 2010 08:30:21 GMTseth delcontehttp://www.sqlservercentral.com/Forums/Topic953159-54-1.aspxI 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?TIAJimThu, 15 Jul 2010 08:18:43 GMTjim.rasmussen