Update Job fails with Invalid object name '##REPLMSTR'

• Sl33py

  Mr or Mrs. 500

  Points: 532

  More actions

  September 8, 2014 at 1:45 am

  #289766

  Hi all

  I have a job that executes a stored procedure every night to update my inventory, last night it failed with Invalid object name '##REPLMSTR'. [SQLSTATE 42S02] (Error 208). The step failed.

  The stored procedure does not create any temp tables, I do however see this table and ##REPLMSTR2

  when I check tempdb.INFORMATION_SCHEMA.TABLES.

  I cant really find anything on google on the function of these 2 temp tables either.

  why would my job fail with this error ?

• September 8, 2014 at 5:42 am

  This was removed by the editor as SPAM