Find text in sp

USE [master] GO /****** Object:  StoredProcedure [dbo].[find_text_in_sp]    Script Date: 11/23/2011 08:52:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[find_text_in_sp] @text varchar(250), @dbname varchar(64) = null, @dbNamePrefix bit = 0 AS BEGIN SET NOCOUNT ON; if @dbname is null begin –enumerate all databases. DECLARE #db CURSOR FOR Select Name from master..sysdatabases declare… Read More Find text in sp