SQL Server Schema Search

ColumnSearch.sql

DECLARE @tableName NVARCHAR(256)
DECLARE @tableSchema NVARCHAR(100)
DECLARE @columnName NVARCHAR(256)

SET @tableName = '%CaseManager%'
SET @tableSchema = 'dbo'
SET @columnName = '%%'

SELECT * 
FROM INFORMATION_SCHEMA.Columns 
WHERE TABLE_NAME LIKE @tableName
    AND COLUMN_NAME LIKE @columnName
    AND TABLE_SCHEMA = @tableSchema

ProcedureSearch.sql

DECLARE @routineName NVARCHAR(256)

SET @routineName = '%%'

SELECT * 
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_NAME LIKE @routineName

TableSearch.sql

DECLARE @tableName NVARCHAR(100)
DECLARE @tableSchema NVARCHAR(100)

SET @tableName = '%%'
SET @tableSchema = 'dbo'

SELECT * 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_NAME LIKE @tableName
AND TABLE_SCHEMA = @tableSchema