SQL search all the stored procedures using linked servers (Database level)

CREATE TABLE #LINKED	
(
	SRV_NAME nvarchar(100)
	,SRV_PROVIDERNAME nvarchar(100)
	,SRV_PRODUCT	 nvarchar(100)
	,SRV_DATASOURCE nvarchar(100)
	,SRV_PROVIDERSTRING nvarchar(100)
	,SRV_LOCATION nvarchar(100)
	,SRV_CAT nvarchar(100)
)
INSERT INTO #LINKED exec sp_linkedservers 

DECLARE @getid CURSOR
DECLARE @name NVARCHAR(100)
DECLARE @sqlCommand varchar(1000)

SET @getid = CURSOR FOR
	SELECT name FROM master.dbo.sysdatabases

CREATE TABLE #RESULTS
(
	DataBaseName nvarchar(100)
	,LinkedServer nvarchar(100)
	,ObjectName	 nvarchar(100)
	,[ObjectType] nvarchar(10)
	,ObjectText nvarchar(max)
	,[DataLength] int
)

OPEN @getid
FETCH NEXT
	FROM @getid INTO @name --@id, @name
	WHILE @@FETCH_STATUS = 0
	BEGIN		
		SET @sqlCommand =  'USE '+ @name +
							' INSERT INTO #RESULTS '+
							' select ''' +
								 @name +''' AS DataBaseName
								  , L.srv_nAME as LinkedServer
								, object_name(tblComment.id) as ObjectName
								, tblObject.type as [ObjectType]
								, tblComment.[text] as ObjectText
								, datalength(tblComment.[text]) as [DataLength]
							from   syscomments tblComment WITH(NOLOCK)
								  inner join sysobjects tblObject  WITH(NOLOCK) on tblComment.id = tblObject.id
								  join #LINKED l on tblComment.[text] LIKE ''%'' + L.srv_nAME + ''%''  COLLATE DATABASE_DEFAULT '
							EXEC (@sqlCommand)									
	  	
		FETCH NEXT
		FROM @getid INTO @name
	END

CLOSE @getid
DEALLOCATE @getid

select * from #RESULTS

drop table #RESULTS
drop table #LINKED