Using Linked Server to store data

I have a linked server setup on my source production server. I also have a secondary server which is the linked server. What I was looking to do is to execute a stroed proc and log connections to the linked server. However I seem to be having issues. > The object name 'MetricDB.Baseline.dbo.WhoIsActive' contains more than > the maximum number of prefixes. The maximum is 2. Metric DB is the destination server which is configured on the source server as a linked server. I been using Adam's sp which was described by Brent here: https://www.brentozar.com/responder/log-sp_whoisactive-to-a-table/ Due to space issues on my production DB I wanted to log it all to another server. Has anyone done this previously? or know if I'm missing something? Thanks