I am trying to query a msdb view on a linked server instance and the query returns results from the local msdb view. The same query works on databases when the linked server is not a named instance. Here's the query...
WHERE database_id = 8
Thanks for any insight or help on this.