Find dependencies of stored procedure in SQL Server
Many a times need arises to find objects a stored procedure depends on. The blogs describes a way to find dependencies of stored procedure in SQL server. The below query creates …
Read MoreTag: sys.dm_sql_referencing_entities
Find dependencies of a table in SQL Server
Many a times need arises to find all objects table depends on or is being referred. This blog will help you to find dependencies of a table in SQL Server. This …
Read MoreFind stored procedure related to column in database in SQL Server
Here is quick query to find stored procedure related to column in database. This comes handy when you have to alter/remove a particular column from a table and you need to …
Read MoreFind stored procedure related to table in database in SQL Server
Many a times need arises to find all stored procedures related to a table in the database. The below queries come handy then. — Query 1 SELECT DISTINCT objects.name, objects.type, comments.text …
Read More