Monthly Archives: November 2011

Searching a string in all tables in a Database

The following  Stored Procedure can help us to search for a string within all columns and rows of all tables in a Database. CREATE PROC SearchAllTables ( @SearchStr nvarchar(100) ) AS BEGIN CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630)) SET … Continue reading

Posted in Knowledge Sharing, SQL Server, Troubleshooting | 4 Comments