We are getting the following error (very intermittently) when one of our asp.net pages calls a stored procedure which in turn calls a function on sql server.
Error occurred in DisplayResults function:
Error occurred in dbObject.GetXMLDoc function:
Invalid object name 'dbo.funcGetID'
It is always a function which is the invalid object and never a stored procedure.
The server that is erroring at the moment is a sql replication subscriber.
I'm just wondering if there is any point at which replication drops and recreates functions so that there is a split second when they cannot be called??? I would be very surprised if that is true but am looking for ideas.
This happens only once or twice a day but is very annoying. The code works fine the rest of the time.
Only got 115 points left. If anyone knows the answer to this then I will up the points to 250.