Early stages of the sql search string for blog post

early_stage_search_script.sql

DECLARE @db_nm varchar(256), @sql_str varchar(1000), @search_str varchar(1000)				

SELECT @search_str = 'tablename'

DECLARE curDB
	CURSOR FOR
	SELECT name 
		FROM master.sys.databases

OPEN curDB
FETCH NEXT FROM curDB INTO @db_nm
WHILE (@@FETCH_STATUS <> -1)
BEGIN

	SELECT @sql_str = 'SELECT distinct db_nm='''+@db_nm+''', OBJECT_NAME=o.name FROM '+@db_nm+'..syscomments s (NOLOCK)
					   JOIN '+@db_nm+'..sysobjects o (NOLOCK) ON s.id = o.id
					   WHERE text LIKE ''%'+@search_str+'%''

					   SELECT TABLE_CATALOG as ''DATABASE'', TABLE_NAME, COLUMN_NAME
					   FROM '+@db_nm+'.INFORMATION_SCHEMA.COLUMNS
					   WHERE COLUMN_NAME LIKE ''%'+@search_str+'%'' or TABLE_NAME LIKE ''%'+@search_str+'%'''
					   
	EXEC (@sql_str)

FETCH NEXT FROM curDB INTO @db_nm

END
CLOSE curDB
DEALLOCATE curDB