问个关于sp_depends的问题

select distinct
s.name + "." + o.name,
convert(char(16), v.name)
from sysobjects o, master.dbo.spt_values v,
sysdepends d, sysusers s
where o.id = d.id
and o.sysstat & 15 = v.number
and v.type = 'O'
and d.depid = xxxx
and o.uid = s.uid

将这些结果插到一个临时表中就可以了xxxx=object_id