Hi Try this approach, it might help you.

DECLARE @DB varchar(200)='DBName1,DBName2,DBName3......'

,@Server varchar(100)='ServerName'

CREATE TABLE #Test(COL1 varchar(20))

WHILE LEN(@DB)>0

BEGIN

DECLARE @hold varchar(100)

DECLARE @Sql VARCHAR(1000)

IF charindex(',',@DB)>0

BEGIN

SET @hold=SUBSTRING(@DB,1,charindex(',',@DB)-1)

END

ELSE

BEGIN

SET @hold=@DB

END

SET @Sql=''

SET @Sql='insert into #Test select top 10 COL1 from ['+@Server+'].['+@hold+'].dbo.TABLENAM1'

EXECUTE (@sql)

IF charindex(',',@DB)>0

BEGIN

set @DB= STUFF(@DB,1,charindex(',',@DB),'')

END

ELSE

BEGIN

SET @DB=''

END

END

SELECT * FROM #Test

DROP TABLE #Test

Thanks,

Neeraj