What might cause SQL error Cannot find the object "dbo.InspectionEvents" because it does not exist o
- by mrtrombone
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