Hello,
I am trying to insert the result set from sp_depends into a table, and I am not sure how to accomplish this. Here is the general idea...
Select sp_depends 'procname'
into #temp
...any help would be appreciated.
Dave
I am having problems with the sp_depends stored proc. It doesn't report any dependencies for certain procs and tables. Can anyone give me an advice on what's going on and how to resolve my problem?
Here is my code and the result from executing it. (my environment is: sql2000, sp1, nt 4.0 sp6).
Thanks,
Peter
use pubs
go
drop table test1
go
drop table test2
go
create table test1 (name varchar(20))
create table test2 (name varchar(20))
go
insert into test1 values ('pete')
insert into test1 values ('mike')
go
drop proc test_proc
go
CREATE PROCEDURE test_proc
AS
create table #tmp (name1 varchar(20))
insert into #tmp
select name from test1
insert into test2(name)
select name from #tmp
go
sp_depends test_proc
go
sp_depends test1
go
sp_depends test2
go
The output I get is:
(1 row(s) affected)
(1 row(s) affected)
Object does not reference any object, and no objects reference it.
Object does not reference any object, and no objects reference it.
Object does not reference any object, and no objects reference it.
what is the sql too use these two together.
sp_msForeachdb sp_depends
Hi all
According to BOL, Stored Procedure SP_DEPENDS will return two result sets , showing Dependency of an object for example a Table
USE Northwind
EXEC sp_depends 'Customers'
But when i execute the above command nothings happens !!! and sql server returns nothing ? why? where am i wrong?
Thanks in advance.
Regards.