Hi, All:

Since yesterday, I noticed that some (only some) of my stored procedures in the database being deleted mysteriously. I am pretty sure this was not a result of human action. I haven't seen this before. Has anyone encountered similiar situation before and why?

Thanks for help.

Samuel

Do you have any SQL server scheduled jobs running that can do that?

No, actually, the dispearing stored procedures are part of a job, which failed because the job could not find the procedure.

Not sure? How that might have happen without human interaction.
do you have a back up? if yes then restore SPs from the backup.

are you running the store procedure directly from the job, if so there is an option to delete the job based on its performance (fail, succeed)

Jaime E. Maccou