How to find a deleted view

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

How to find a deleted view

Postby dlbridgeman » Mon Jul 29, 2013 1:47 pm

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?

Posts: 3
Joined: Mon Jul 29, 2013 1:43 pm

Postby james.billings » Wed Jul 31, 2013 2:13 pm

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:

Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests