Previously posted about finding content in a SQL Stored Procedure. Here is a nice script that creates a new Stored Procedure called SearchAllTables that will scan all tables and columns for a string input: CREATE PROC SearchAllTables ( @SearchStr nvarchar(100) ) AS BEGIN DECLARE @Results TABLE(ColumnName nvarchar(370), ColumnValue nvarchar(3630)) SET NOCOUNT [...]