Find Any Values from Database
--EXEC [SearchProcedure] '835_FinancialInformation' --EXEC sp_depends [835_FinancialInformation] DECLARE @SearchStr NvarChar(100) SELECT @SearchStr = 'Missing/incomplete/invalid upgrade' CREATE TABLE #Results ( ColumnName nvarchar(370),ColumnValue nvarchar(3630) ) SET NOCOUNT ON DECLARE @TableName NvarChar(256), @ColumnName NvarChar(128),@SearchStr2 NvarChar(110) SET @TableName = '' SET @SearchStr2 = QuoteName('%' + @SearchStr + '%','''') WHILE @TableName Is Not Null BEGIN SET @ColumnName = '' SET @TableName = ( SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName AND OBJECTPROPERTY( OBJECT_ID( QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) ), 'IsMSShipped' ...