John Cooper (5/22/2014)
Thanks Jeff,That's what I have been doing is opening it in SSMS, clicking on properties and then OK.
I was wondering if someone had found a better way. I manage 45 servers with 5 Linked Servers each so even though the properties
tab thing works, it's not practical.
I wonder if there is a programmatic way of doing it maybe? I'm going to investigate that.
I'd do a trace/xevent session against a dev server when opening the linked server properties window to identify what that actually does and then maybe try running a script that duplicates those actions against another dev server to see if it fixes the problem.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question