Hi, one of my Stored procedure got corrupted is there anyway to prevent this from happening again? Is there a DMV that I can run to see if a stored procedure is corrupted?
I found out about the corruption from our software vendor
what do you mean by "corrupted"?
Encrypted perhaps?
My reckoning is:
If the Sproc is corrupted then the database is corrupted, otherwise the original CREATE PROCEDURE would have failed.