Well hi,

I am Mohammed Suhail ahmed working on Business Objects.

My client wants me write such a stored procedure to get the tables involved.

He need to display the table name(s) in...

i got the solution in this way..

thnx and let me know if any possible way

alter procedure proc1

as

begin

select * from student

insert into cust1 values('eric')

exec sp_depends proc1

end

----------------------------------------------

create procedure proc2

as

begin

CREATE TABLE...

well i wrote sample stored procedure in this way:-

alter procedure proc1

as

begin

select * from student

insert into cust1 values('eric')

exec sp_depends proc1

end

exec proc1

output i got like:

dbo.sp_depends ...