Monthly Archives: September 2011

Search for text in Stored Procedures

Very handy when you are asked to create a trace for a stored procedures that update text in a specific table. Then you want a way to search fast within all sp’s in your database. SELECT distinct sysobjects.name FROM sysobjects … Continue reading

Posted in DBA, SQL Server | Leave a comment