Friday, July 23, 2010
In SQL Server if we want to search any text in our database stored procedure then execute below query in your SQL server management studio,
CAST(o.[name] AS VARCHAR(40)) AS objectname ,
FROM syscomments cinner
JOIN sysobjects o ON c.[id] = o.[id]
WHERE c.[text] LIKE ‘%Find Text%’
ORDER BY o.type
you just replace “Find Text” to your search string in query.