show history for dropped objects
I dropped a sp and I would like to know in which version I dropped it (I'm entering our version number in the comments)
History is shown for dropped objects. Right click on the database or the object’s folder (e.g., Tables) and select show history. You will see dropped objects in the list.
-
Sriram Garimella commented
We are using TFS and thank you for the suggestion. I would suggest you to add another tab for searching the objects(both active and inactive) and inactive ones can be in grey, it would really be helpful.
-
@Sriram - which source control system do you currently use? Although not possible in the SQL Source Control UI, it should already be possible to use your source control client tool to locate deleted objects and view the history.
-
Sriram Garimella commented
Please update me if this feature is already there or coming in future releases