SQLTeam.com | Weblogs | Forums

Stored Procedure got corrupted


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.