Invalid object name ‘BizTalkDTADb.dbo.Tracking_Parts1′
I have been in a customer recently that had this rare alert in the SQL Server Log while running the TrackedMessages_Copy_BizTalkMsgBoxDb job (never seen before) “Executed as user: USERNAME . Invalid object name ‘BizTalkDTADb.dbo.Tracking_Parts1′ . [SQLSTATE 42S02] (Error 208). The step failed.” At first glance i thought it was a security issue concerning the SQL Server Agent account rights within the database but it was not the case, since the SQL Server agent was well configured and has access to all databases in the instance
Read the rest here:
Invalid object name ‘BizTalkDTADb.dbo.Tracking_Parts1′
