Link to home
Start Free TrialLog in
Avatar of csePixelated
csePixelatedFlag for United States of America

asked on

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

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.
Avatar of csePixelated
csePixelated
Flag of United States of America image

ASKER

ASKER CERTIFIED SOLUTION
Avatar of csePixelated
csePixelated
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial