How to Find PRocedure String

Posted by Jayakumars under ASP.NET AJAX on 4/5/2013 | Points: 10 | Views : 772 | Status : [Member] [MVP] | Replies : 3
Hi

I have 100 Stored Procedure in Sql here i need how many procedures have

Select * from emp Table so i find how many procedures i have use

emp -> table i need list out all stored procedure how will do this.

Mark as Answer if its helpful to you


Responses

Posted by: Murugavelmsc on: 4/5/2013 [Member] Starter | Points: 25

Up
0
Down
http://sqlexplore.wordpress.com/2011/02/23/sql-server-%E2%80%93-2008-%E2%80%93-list-of-all-stored-procedure-in-database/

Regards,
Murugavel S
murugavel.sadagopan@gmail.com
http://murugavelmsc.blogspot.in/

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Satyapriyanayak on: 4/5/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
----Option 1
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%tablename%'
----Option 2
SELECT DISTINCT o.name, o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%tablename%'


Refer
http://blog.sqlauthority.com/2006/12/10/sql-server-find-stored-procedure-related-to-table-in-database-search-in-all-stored-procedure/

If this post helps you mark it as answer
Thanks

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Murugavelmsc on: 4/5/2013 [Member] Starter | Points: 25

Up
0
Down
http://www.dotnetfunda.com/codes/code30-list-out-code-of-all-stored-procedure-in-sql-server-database.aspx

Regards,
Murugavel S
murugavel.sadagopan@gmail.com
http://murugavelmsc.blogspot.in/

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response