=========================================================================
Author: Ram Shankar Yadav
Create date: May 22, 2007
Description: Used for administrative purpose to find a particular text
in the database for example columnName, Table name etc etc
=========================================================================
CREATE PROCEDURE [dbo].[FindTextInDatabase]
-- Add the parameters for the stored procedure here
@text varchar(200)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
declare @newString varchar(205)
Set @newString = '%' + @text + '%'
-- Insert statements for procedure here
select name from sysobjects where id in
(select id from syscomments where text like @newString)
order by name
END
Happy Coding 