This post originated from an RSS feed registered with .NET Buzz by Steve Hebert. Original Post: Sql Dependency Viewer and large database projects Feed Title: Steve Hebert's Development Blog Feed URL: /error.htm?aspxerrorpath=/blogs/steve.hebert/rss.aspx Feed Description: .Steve's .Blog - Including .Net, SQL Server, .Math and everything in between Latest .NET Buzz Posts Latest .NET Buzz Posts by Steve Hebert Latest Posts From Steve Hebert's Development Blog

I’ve been playing with Red-Gate’s Sql Dependency Viewer which is currently in Beta.  During this beta period, Red-Gate  is allowing people to download the tool for free.

I’ve run into a few dependency viewers based on sysdepends in various blogs, but I’ve always run into problems with one project I worked on.  The database had so many stored procs, functions and tables that these tools never completed their work after running overnight.  I decided to turn Sql Dependency Viewer on this project and see what it could do. 

I was impressed that it took 20 seconds to read all dependencies.  While the resulting graphical view was nearly unreadable – it looked like something out of Microsoft’s free code profiler for .Net – but it still had a number of extremely useful functions. 

I can give it any object name to search for and it immediately displays the object in question.  When looking at a stored proc, I can immediately see which stored procs are calling it, what stored procs and functions it is calling, what tables it is reading from and what tables it is writing to.  This view is extremely useful in a large project. I would have loved to have had this tool when I first started working on it. 

It’ll be interesting to see this tool progress and any improvements to the graphical display.