Database Scripts

Beta
 Log In    |   Sign Up

SQL Server : List of Stored Procedure from Table

Added on Jun-28-2012 by venushakamuri
For SQL Server

Tags : sql server

List of Stored Procedure from Table

Versions

sql server

DOWNLOAD

SELECT Distinct SO.Name
FROM sysobjects SO (NOLOCK)
INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID
AND SO.Type = 'P'
AND (SC.Text LIKE '%UPDATE%' OR SC.Text LIKE '%INSERT%')
ORDER BY SO.Name

    

Report Script

blog comments powered by Disqus