Red Gate forums :: View topic - Retrieve latest version of a deleted stored procedure
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Retrieve latest version of a deleted stored procedure

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sderrico



Joined: 14 May 2012
Posts: 3
Location: Montreal

PostPosted: Tue Sep 17, 2013 2:50 pm    Post subject: Retrieve latest version of a deleted stored procedure Reply with quote

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
_________________
Sébastien D'Errico
IT Development
sebastien@hollox.net
(438-882-8687
Back to top
View user's profile Send private message Send e-mail MSN Messenger
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Thu Sep 19, 2013 11:00 pm    Post subject: Reply with quote

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/39019-sql-source-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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group