Showing posts with label Searching text from stored procedures. Show all posts
Showing posts with label Searching text from stored procedures. Show all posts

Sunday, December 18, 2011

Searching String or text from "stored procedure" defination

SELECT DISTINCT o.name ,o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%Employee%'
GO