December 27, 2004 at 8:19 am
Hello friends, one mine friend accidentally compiled a store procedure, he wants recover the last version compiled .
One can recover the last version of store procedure before the compilation?
Thanks...
December 27, 2004 at 8:28 am
No.
December 27, 2004 at 9:01 am
No, unless you've got a backup with the version you want to recover.
Scott Thornburg
Volt Information Sciences
December 27, 2004 at 9:09 am
Thanks, my friend is very sad
December 27, 2004 at 10:54 am
sorry to hear that. a good reason not to use EM to edit and instead use a flat file in Query Analyzer that is under source control.
December 28, 2004 at 10:25 am
Aren't procs stored in syscomments? Would edits to syscomments be logged in the same way as edits to normal tables are? Would a 3rd-party tool which allows a user to decipher SQL's built-in transaction logs be able to extract that information?
December 28, 2004 at 11:14 am
OK thanks anyway now my friend has learned the lesson,thank you .
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply