What might cause SQL error Cannot find the object "dbo.InspectionEvents" because it does not exist o

Posted by mrtrombone on Stack Overflow See other posts from Stack Overflow or by mrtrombone
Published on 2010-03-14T20:22:27Z Indexed on 2010/03/14 20:25 UTC
Read the original article Hit count: 324

Filed under:
|
|

Hi

My ASP.Net app is periodically getting the error 'Cannot find the object dbo."XXXX" because it does not exist or you do not have permissions' when it tries to execute a specific stored procedure that writes to the database.

I have seen a few forum posts about this issue but the strange thing is that the method works fine almost all of the time, just every now and then I see it in my error logs.

Can anyone tell me why this might works Ok most of the time but occassionally fire the error?

Application is C# using Enterprise Library 4.1 Data Access. Database is SQL Server 2005

Cheers

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about ASP.NET