To Get SP Details
May 22, 2009 at 7:30 pm | In SQL | Leave a CommentHi
These are the 2 queries to get the Sored Procedure details related to a Particular Database and Particular Table.
use db name
Select * From sys.sysobjects where type=’p’
SELECT * from sys.sysobjects so
inner join sys.syscomments sc
on so.id=sc.id
where type=’p’ and sc.text like ‘%TableName%’
where p stands for the sproc.
No Comments Yet »
RSS feed for comments on this post. TrackBack URI
Leave a comment
Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.
