CREATE PROC SearchAllTables
(
    @SearchStr nvarchar(100)
)
AS
BEGIN
    CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))
 
    SET NOCOUNT ON

Set NoCount ON
 
Declare @tableName varchar(200)
 
set @tableName=''
 
While exists
 
(