Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Kshitij Satpute,
The script will provide the list of all programmable DB objects and the objects being refered.
The objective of the script is to have a map of your database dependencies in the form of view for debugging and analysis purpose.
The known limitation all such methods is that we cannot dig in to map dependencies where dynamic queries are used.
Invalid object error
object name from objid
sql server 2000 - object privileges
SSIS 2008 Object Model
ASCMD to process objects