I have an SQL server that has started having trouble with stored procedures about once every three months. A stored procedure that is run every night suddenly fails, with different error messages, and if we go to SQL Manager – Manage – Stored Procs, load the stored procedure and then resubmit the *exact* same stored procedure it works fine.
It appears to be happening to different procedures, and I can’t find anything amiss. I have checked the MSKB, and other sources and not found anything.
It appears to me that the compiled SP map is being corrupted somehow, but I can’t find the culprit.
Has anyone heard of this? Does anyone know what could be causing this or a fix?
Thanks!
Charles…