I tried it like

Inser into #tmp

Exec linkedserver.db.dbo.mysp

Then it is giving me error but when I directly run following statement then it gives me output

linkedserver.db.dbo.mysp