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?