Detect Object dependencies.

This stored procedure will detect all first level object dependencies on Stored Procedure.The result set will be stored in table Depend. Unlike sp_depends, sp_MSdependencies will be able to detect all links and dependencies associated to an object. It includes TRIGGER, DELETE, UPDATE etc .

2004-07-30 (first published: )

314 reads

Blogs

Daily Coping–3 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Data Céilí 2020 Cancelled

By

Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing...

Code from Redgate Streamed

By

I presented a session today at Redgate Streamed and did a number of demos....

Read the latest Blogs

Forums

Basic SQL Question

By porterdl

I am new to SQL and I am having a hard time finding resources...

Delet old backup in azure

By abdalah.mehdoini

Hello, How to delete backups in blob storage from azure sql server VM to...

Fully Qualified Name

By inspector

First time poster...not sure this the correct section to post this question.  I have...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers