Retrieve latest version of a deleted stored procedure

sderrico

Hello,

Questions:
1) How can I retrieve the latest version of a deleted stored procedure?
2) Is there are any filter in the window "History" ? Example: i would like to filter all revisions related to this specific stored procedure.



Thank you,
Have a great day!
Sebastien

Manfred.Castro

1) How can I retrieve the latest version of a deleted stored procedure?

You would need to go through the history and find the revision where the table was dropped. This would show the latest version of the stored procedure prior to the drop.

2) Is there are any filter in the window "History" ? Example: i would like to filter all revisions related to this specific stored procedure.

You can right click on a specific object in Object explorer and select show history this will bring up all the revisions that are associated with that object.
Unfortunately this will not work for you because the object was deleted.
If you wish you can request a feature for this particular case in our uservoice forums.
http://redgate.uservoice.com/forums/390 ... ce-control
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.