SQLTeam.com | Weblogs | Forums

Stored Procedure got corrupted


#1

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?


#2

I found out about the corruption from our software vendor


#3

what do you mean by "corrupted"?


#4

Encrypted perhaps?

My reckoning is:

If the Sproc is corrupted then the database is corrupted, otherwise the original CREATE PROCEDURE would have failed.