August 4, 2011 at 12:24 pm
my linked server uses domain name "http://srv.sql.example.com" to connect to other instances
problem is that when the domain is updated with new IP address, the change is propagated within 5-10 minutes everywhere, even to the sqlserver instance but the linked server takes 1-2 hrs to update...
I was wondering if there is any setting which holds the refresh time of inked server without recreating it
thanks for the help!!
August 4, 2011 at 1:02 pm
Can you use the UI to script out your linked server and post it here? That might help me understand your configuration.
Jimmy
"I'm still learning the things i thought i knew!"Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy