February 07, 2011

To list all the dependent objects of a table in SQL Server

Below statement will list all the related stored procedures, tables....

EXEC sp_MSdependencies N'dbo.[TABLE_NAME]', null, 1315327


No comments:

Post a Comment