dwilliscp (5/13/2013)
I do not have permissions on the server.. and there is a lot of red tape to get anything installed.However I did use the SQL provided... with a few changes... thanks for everyones help.
; with base as
(
SELECT DISTINCT o.name as Calling_Name
, o.type_desc as Calling_desc
, p.name as Called_Name
, p.type_desc as Called_Desc
FROM sys.sql_dependencies d
INNER JOIN sys.objects o
ON d.object_id = o.object_id
INNER JOIN sys.objects p
ON d.referenced_major_id = p.object_id
)
select * from base
where [called_name] like 'zt_MSC%'
order by called_name, Calling_name
You don't need to install RedGate search on a server. It's SSMS add-in and you should install it on on your desktop/vm. It's one of the most used SQL development tools, provided for free by one of the most known software companies specializing in this area.
As I said before sys.sql_dependencies may not contain data for all dependent objects.
If you go this way, you better to check syscomments too.