Finding Dependencies in SQL Server

9 November 2010

I think that anyone who has used the system stored procedure sp_depends to find dependencies in SQL Server will have discovered¬† that the results cannot always be relied upon.¬† Most notably, this can occur when modules (procedures, views etc) have been created out of dependency order.¬† It seems that SQL Server only populates sys.depends values […]

Read the full article →