OPENDATASOURCE- experience with;any other way of not using linked servers
-
We are attempting to get away with having to manage linked servers in our sql coding. Instead we just want to use IP addresses/ instances. Does anyone have any experience using OPENDATASOURCE on a large scale or is there any other way of referencing other servers other than their linked server names?
-
Just for giggles...
What happens if (not this EVER happens) your Network guys MOVE the network segment that your box is on and forget to tell you?
I know this from experience. Not only did they MOVE the segment and change the IP of the server they didn't tell any.
We used 2 different NICs in the server 1 for users to connect and the other for backups and talking to other servers. Luckily because we used the server name and NOT IP we were ok...
You can reference IP\instance in your connections but WHY? Linked server in SQL is easy, simple to manage and doesn't hurt anything and has decent security.....
Good Hunting!AJ Ahrens
webmaster@kritter.net -
Since the network guy sits right next to me I would reach over and whack him.
Seriously, he is asking for the change and would have to answer to our boss if he did something like that. We're just trying to get away with using "names" to link everything.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply