We help IT Professionals succeed at work.

cannot connect to Local on sql 2016 when another sql server is linked

csePixelated
csePixelated asked
on
49 Views
Last Modified: 2019-01-22
I have a sql query that compares identical tables between 2 linked sql servers.
cdiserv5 linked to cdiserv6, we recently updated from sql 2008r2 to sql 2016, and for some reason I cannot get my old query to work, primarily because once i link the servers the (local) server is not listed in Sis.Servers, is there a default name i need for the local server.
Comment
Watch Question

This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION