Retrieve latest version of a deleted stored procedure

sderricosderrico Posts: 5
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.

img00010.png

Thank you,
Have a great day!
Sebastien
Sébastien D'Errico
IT Development
sebastien@hollox.net
(438-882-8687

Comments

  • 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.
    Manfred Castro
    Product Support
    Red Gate Software
Sign In or Register to comment.