Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xhostx
Constraint Violating Yak Guru
277 Posts |
 Posted - 2012-06-27 : 08:38:47
|
| I have a script that I run few times a month.The data i need to access is stored locally in one of a company's servers. I have created a script that collect some info from other remote servers, my script usually runs remotly using Remote desktop and then access windows command to execut a .SQL file.My situation is : At the run time of my script remotly, I will need to compare some data from the first server with data that's stored in the client databases (remote) using my local machine (Remote desktop). It is complex in away that there will be 3 machine involved. Im thinking to generate text files from my local database manually, load the same data into a the remote servers, and them run the audit from my machine.I have the IP adress of the server, name of the server, login, and password. I connect to the server using the remote desktop.someone mention that I can use the sp_addlinkedserver! Please, any idea, thought, suggestion will be appreciated! Thanks,--------------------------Get rich or die trying-------------------------- |
|
|
|
|
|
Remote data Access Case