SQL Server Education (by the geeks, for the geeks)
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 …
Find dependencies of stored procedure in SQL Server Read MoreHere 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 …
Find stored procedure related to column in database in SQL Server Read MoreMany 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 …
Find stored procedure related to table in database in SQL Server Read More