February 16, 2007 at 9:32 pm
Hi all Experts,
Generally we use SP_Depends for finding all tables functions and subprocedure for particlar sp.
Ex. SP_depends sp_MySP
It give me all Tables name, functions name and subprocedures Name.
But sp_depends is not accurate, I want to get a Single Query which give all objects name which is used in the sp........
Thanx for your Suggestions In Advance.
February 18, 2007 at 11:26 pm
select object_name(id) from syscomments where id = object_id('objectname')
Above query returns the object name even it is marked as comments...
http://msdn2.microsoft.com/en-us/library/ms345449.aspx
MohammedU
Microsoft SQL Server MVP
February 19, 2007 at 12:11 pm
Try this procinstead - sp_MSdependencies
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
February 19, 2007 at 11:43 pm
Thanx for This Valuable SP
I got the Result i Needed , Is This sp works for the sql server 2005....
regards
shashi kant
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply