December 29, 2003 at 11:41 pm
I want to list out the tables that are affected by a stored procedure in SQL Server.using "SP_depends Stored procedure Name" i can get the tables that are affected by the stored procedure.The problem here is it is giving the tables of the current database only.
say i am having two databases database1 and database2.
database1 is having the stored procedures
Storedprocedure1 -affects the tables of database1
Storedprocedure2 - affects the tables of database2
now if i run the sp_depends storedprocedure1 it works fine but for the Storedprocedure2 it is not working reason is it affects the tables of database2.
December 31, 2003 at 10:38 am
I'm not sure there is a good way to do this. My guess is that only your documentation would cover this.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply