To search the whole database for a string in the tables. This stored procedure will return the tables and result set with the matching search string.
sp_generate_inserts written by Sorna.
To search in a all table
EXEC SP_SearchTables @Tablenames = '%', @SearchStr = '%TEST%'