August 28, 2008 at 8:29 am
Hi,
I have a question : is there a way to find a "history" for the stored procedures,what was modified and when, for a "procedure recovery"?
In there a way using the transaction log ?
Thank you
August 28, 2008 at 8:39 am
What do you mean by history? What information are you looking for? If it's code history, you should be using a version control system, and I know SQLCompare can compare against a backup file.
If you want execution history, you need something like Profiler or SQL Trace.
August 28, 2008 at 8:42 am
Yes.I mean code history...
I want to ask...for example if there were 10 alteration on the code...can I get the first or the second version of the procedure?...I hope I'm being clear.
August 30, 2008 at 1:35 am
No unless you have any version control system as told by Steve
[font="Verdana"]Thanks
Chandra Mohan[/font]
August 30, 2008 at 8:59 am
Of course you could also write this yourself with the ALTER PROCEDURE DDL trigger.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 30, 2008 at 3:17 pm
Idera's Compliance Manager can tell you when changes were applied. I can't remember if it captures the actual SP code, or just logs that ALTER PROCEDURE occured by Person_A on YYYYMMDD.
September 5, 2008 at 4:42 am
you can use version control tools like MS Visual Source Safe,
ClearCase ...
it is not a better advice to write a DDL Trigger on Production Server.
please correct me if i am wrong any DATABASE experts.
Regards,
Manoj
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply