Track SQL Dependencies

--PAYROLL.dbo.PAY_GETPAYLIST dependents on

EXEC sp_depends @objname = N'PAY_GETPAYLIST' ;

--dependent on PAYROLL.dbo.PAY_GETPAYLIST

EXEC sp_MSdependencies N'dbo.PAY_GETPAYLIST', null, 1315327

--PAYROLL.dbo.PAY_GETPAYLIST dependents on

--oType =1 (Scalar Function), oType =8 (Table)

EXEC sp_MSdependencies N'dbo.PAY_GETPAYLIST', null, 1053183

-- SYS COMMENTS

SELECT distinct so.name

FROM syscomments sc

INNER JOIN sysobjects so ON sc.id = so.id

WHERE charindex('PAY_GETPAYLIST', text) > 0

--INFORMATION_SCHEMA.ROUTINES

SELECT routine_name, routine_type

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%PAY_GETPAYLIST%'