SQL Server - Listar los procedimientos alamacenados de una base de datos que contengan cierta tabla y columna

CREATE proc dbo.p_FindText

@strFind varchar (100),

@varDBName varchar (100) = 'Northwind'

AS

	BEGIN

		SET NOCOUNT ON

		DECLARE @SQLString nvarchar (1000)

		SELECT @SQLString = N'SELECT distinct ' +

		'name SP_Name, ''sp_helptext '''''' + name + ''''''''SP_HT ' +

		'FROM [' + @varDBName + '].[dbo].[sysobjects] inner join [' + @varDBName + '].[dbo].[syscomments] ' +

		'on [' + @varDBName + '].[dbo].[sysobjects].id = [' + @varDBName + '].[dbo].[syscomments].id ' +

		'where xtype = ''P'' ' +

		'and text like ''%' + @strFind + '%'' ' +

		'order by name '

		exec sp_executesql @SQLString

    END