use master
go

drop database test_sysdepends
go

create database test_sysdepends
go

use test_sysdepends
go

create table MyTable01 (id int)
go

create proc MyProc01
as
    select id from MyTable01
go

create proc MyProc02
as
    create table #t (id int)

    -- comment this next line out and the dependency is picked up.
    -- but as long as we insert into the temp table, we don't pick it up... :(
    insert into #t 
    select id from MyTable01

    select id from #t
go


select     
    so2.name as parent    
    ,so1.name as dependent 
from sysdepends d
join sysobjects so1 on d.id=so1.id
join sysobjects so2 on d.depid=so2.id
go

parent     dependent
---------  ---------
MyTable01  MyProc01

quote:

---

Originally posted by jezemine

ah, that's lame - I hardly ever use select...into because of the table locks it causes.

bummer it works for that and not for insert...select

---

www.elsasoft.org

---