Query for searching the entire database for a string value To run this query in your own senerio, just change the ‘Cal’ to any string you desire DECLARE @Database Varchar(255) DECLARE @Schema Varchar(255) DECLARE @TableName Varchar(255) DECLARE @ColumnName Varchar(255) DECLARE @SqlCmd Varchar(255) DECLARE @Search Varchar(1000) SET @Search = 'Gary' SET @Search = '''%'+@Search+'%''' –PRINT @Search [...]