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

No comments:

Post a Comment