Sunday, February 19, 2012

How to Filter only stored procedure when executing sp_depends ?

Hi !
I'd like to filter only the stored procedure when executing sp_depends on a
table.
How can I do that easily ?
Thx for your help.
JeffCreate a temporary table to store the sp result.
Example:
use northwind
go
create table #t (
[name] sysname,
type varchar(50)
)
insert into #t
exec sp_depends orders
select
*
from
#t
where
type = 'stored procedure'
drop table #t
go
AMB
"Jeff37" wrote:

> Hi !
> I'd like to filter only the stored procedure when executing sp_depends on
a
> table.
> How can I do that easily ?
> Thx for your help.
> Jeff

No comments:

Post a Comment