Retrieve latest version of a deleted stored procedure

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Retrieve latest version of a deleted stored procedure

Postby sderrico » Tue Sep 17, 2013 2:50 pm

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.

Image

Thank you,
Have a great day!
Sebastien
Sébastien D'Errico
IT Development
sebastien@hollox.net
(438-882-8687
sderrico
 
Posts: 3
Joined: Mon May 14, 2012 12:32 pm
Location: Montreal

Postby Manfred.Castro » Thu Sep 19, 2013 11:00 pm

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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest