Database Scripts

Beta
 Log In    |   Sign Up

SQL Server : Find Stored Procedure Related to Table in Database

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

Tags : sql server

Find Stored Procedure Related to Table in Database – Search in All Stored Procedure

Versions

SQL SERVER

DOWNLOAD

SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%tablename%'

    

Report Script

blog comments powered by Disqus