How to find a deleted view

dlbridgemandlbridgeman Posts: 4
edited July 31, 2013 10:13AM in SQL Source Control Previous Versions
I have found that a view which one of my applications depends on has been deleted by someone at some point. How do I find the revision where this happened? Is there a way that I'm not seeing to search history, aside from clicking on each revision?

Thanks,
Dan
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    Within SSMS there's no easy way that I'm aware of.

    It's probably a job better suited for the native tool you'd use with your source-control system. For instance, with TortoiseSVN I can right-click on the Views folder in my repository and see all the history of operations, then filter by filename:

    15ywzkg.png
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.