Stored Proc to list all object dependencies | SansSQL

Saturday, June 7, 2008

Stored Proc to list all object dependencies

EXEC sp_depends 'Object Name'
Go
sp_depends displays information about database object dependencies.
sp_depends displays two result sets. First One shows the objects on which the 'given
object' depends and the second shows the objects that depend on the 'given object'

Ads