Get list of tables used in Stored procedure

SELECT DISTINCT        so.ID, so.name AS 'Procedure Name' , oo.name AS 'Table Name'

FROM sysdepends d, sysobjects so, sysobjects oo

WHERE    so.id=d.id

      AND so.name= 'Stored_Proc_Name'   -- Enter Your stored Procedure Name here

      AND oo.id=d.depid

ORDER BY so.NAME,oo.NAME

Find a sting in SQL table

CREATE PROCEDURE dbo.FindStringInTable @stringToFind VARCHAR(100)

AS

BEGIN TRY

 

   DECLARE @sqlCommand varchar(max) = 'SELECT * FROM [dbo].[TableName] WHERE '

          

   SELECT @sqlCommand = @sqlCommand + '[' + COLUMN_NAME + '] LIKE ''' + @stringToFind + ''' OR '

   

   FROM INFORMATION_SCHEMA.COLUMNS

   

   WHERE TABLE_SCHEMA = 'dbo'

   

   AND TABLE_NAME = 'TableName' -- This condition can be removed.

   

   AND DATA_TYPE IN ('char','nchar','ntext','nvarchar','text','varchar')

   SET @sqlCommand = left(@sqlCommand,len(@sqlCommand)-3)

   

   EXEC (@sqlCommand)

   

   PRINT @sqlCommand

END TRY

BEGIN CATCH

   PRINT 'Unknown Error !!'

END CATCH

 Execute FindStringInTable '[String to Search]'