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