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

csePixelated
csePixelated used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
never mind, I simply removed the server from the query and it worked fine.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial