>>I have seen this happen when a large pending transaction errors out and nerver commits.
>
>Exactly, that's my situation. Because the sp_MsForEachTable 'DROP TABLE ?' no longer works, because again the interface cannot find this stored procedure, all the rest of the code fails. So, I am removing that right now and replacing that with a if condition before each table process to drop it, if it exists, before creating it.
Did you trying to reference it with the full name (master.dbo.sp_MSForEachTable)? Just speculating, not sure it would work.
Though it's strange.
If it's not broken, fix it until it is.
My Blog