Interview Questions and Answers
How to identify object dependencies in SQL Server
There are several ways to find object dependencies in SQL Server
1. View Dependencies feature in SQL Server Management Studio
2. SQL Server dynamic management functions
sys.dm_sql_referencing_entities
sys.dm_sql_referenced_entities
3. sp_depends system stored procedure
2. SQL Server dynamic management functions
sys.dm_sql_referencing_entities
sys.dm_sql_referenced_entities
3. sp_depends system stored procedure
Post a Comment
0 Comments