>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.