add option to view commited deleted object code from repsostiry in SSMS
Currently there is not easy way to see or restore a deleted object that was committed. The object code is still in Source Control - but no easy way to see or restore it using SSMS.
![](https://secure.gravatar.com/avatar/ee13c366553a341dcdf6cf4abcbf75c1?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
![](https://secure.gravatar.com/avatar/afe700e0a01f4aaffb721c18101e775e?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
I believe that this is achievable by viewing object history in SQL Source Control and then launching SQL Compare or SQL Data Compare to do a diff and potentially restore the prior version. More info is here: https://documentation.red-gate.com/soc7/common-tasks/update-to-a-revision-from-source-control
This does require having licenses for SQL Compare and SQL Data Compare, however, and your suggestion is specific to doing this with SSMS, so I am not marking this as complete.
-
Horst commented
Implement a seach function will be very helpfull to find those deleted/dropped objects. Search the history by hand is not very efficient.
-
Michael Murphy-McCarthy commented
Kendra, that only works if you can find it. Finding a deleted/dropped object requires manually going through the history. There is no way to search for a deleted object.