I am currently experiencing an intermittent issue where a stored procedure called by an application returns:
[Microsoft][SQL Native Client][SQL Server]Invalid object name 'dbo.MyTable'., State:S0002
I thought it could have been a permissions issue for the application but as it happens intermittently this doesn't appear likely.
The proc calls many other tables which it seemingly has no problems with, although I have had some deadlock errors which is my only other idea as to what could be going on.
Hope you can help,
My first thought is, yeah, you could experience that from a deadlock situation if you're dealing with a temporary table of some type that is no longer a part of the situation, but from your answer posted in response to @askmlx121 comment, I'm wondering if you're hitting deadlocking at all.
Are you seeing deadlock errors along with this error or just this error? If it's just this error it sounds more like a security issue than a deadlock or blocking problem. And no, I wouldn't expect to see an object doesn't exist error because of blocking.
Just we're level set, a block is when resource is waiting on other resources. A dead lock is when two resources each has a resource the other needs, forcing the other to wait for infinity. One is chosen as a deadlock victim and the transaction is rolled back.
answered Feb 23, 2013 at 02:25 PM
Grant Fritchey ♦♦