How to search for a value, in all columns of a Microsoft SQL Server Database
If you want to search in for a specific value in all columns of a Microsoft SQL Server Database, you can use the following T-SQL stored procedure: CREATE PROC SearchAllTables( @SearchStr nvarchar(100) ) AS