How do I search an SQL Server database for a string?
This will search every column of every table in a specific database. Create the stored procedure on the database that you want to search in. The Ten Most Asked SQL Server Questions And Their Answers: CREATE PROCEDURE FindMyData_String @DataToFind NVARCHAR(4000), @ExactMatch BIT = 0 AS SET NOCOUNT ON DECLARE @Temp TABLE(RowId INT IDENTITY(1,1), SchemaName sysname, … Read more