How to find a deleted view

dlbridgemandlbridgeman Posts: 4
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

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

Sign In or Register to comment.