Discussion Locked

SQL Server corrupt Stored Procedures...

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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...

2 replies

by stillatit

If you do NOT reload the procedure, but try to manually execute it, does it still fail? If not, it may be something in the execution environment that is the problem (memory, locks, etc.)

Good luck.

by cviescas

Yes, it will still fail. (Usually with various different error messages, non of which I have seen that *is* the problem. Incorrect variable type, can't find a column or table, etc.)

Charles...

This discussion is closed to new replies.