Friday, September 28, 2012
Find Stored Procedure Related to Table in SQL Server
Following the code support for find all the Stored Procedures related to the table.
SELECT
DISTINCT
so
.
name
FROM
syscomments
sc
INNER
JOIN
sysobjects
so
ON
sc
.
id
=
so
.
id
WHERE
sc
.
TEXT
LIKE
'%tablename%'
Newer Post
Older Post
Home