search something from db
DECLARE @tabname NVARCHAR(50)
DECLARE @colname NVARCHAR(50)
DECLARE mycursor CURSOR FOR
SELECT so.[name],sc.name
FROM sysobjects so
INNER JOIN syscolumns sc ON (so.id=sc.id)
WHERE so.xtype='U' AND sc.name LIKE '%user%'
AND so.NAME NOT LIKE 'Audit%'
OPEN mycursor
FETCH NEXT FROM mycursor INTO @tabname,@colname
WHILE(@@FETCH_STATUS=0)
BEGIN
--PRINT 'select * from '+@tabname+' where '+@colname+' like ''%IamV%'' '
EXEC('select * from '+@tabname+' where '+@colname+' like ''%IamV%'' ')
IF @@ROWCOUNT>0
BEGIN
PRINT @tabname
END
FETCH NEXT FROM mycursor INTO @tabname,@colname
END
CLOSE mycursor
DEALLOCATE mycursor

