Archive for September, 2013

Find text in stored procedures on your SQL Server Database

tres handy..

select * 
from syscomments
where [text] like '%ASPStateTempApplications%'

 -- > SQL 2005
select * from sys.sql_modules
where definition like '%ASPStateTempApplications%'

No Comments