SQL Server Performance Forum – Threads Archive

Communication between databases

I have a question :
There is a database A and Database B, if stored procedure in A is querying a table in database B, How is the connection between Databases A and B is established in the first place and communication happenning, if say A and B are at different geographical location? Is it through the network, Does the Server which hosts A stores IP address of the server which hosts B. Please forgive me if the question is stupid and provide an answer.
Thanks in advance
Rajesh

---

etr Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

---

What is etr? Madhivanan Failing to plan is Planning to fail

---

Rajesh, the questions you are asking are fairly basic, but they cover a LOT of territory. Go to Books Online index tab. Look up the following terms: "linked servers", "users-SQL Server", "logins-SQL Server", and "authentication". Read each of the articles and all the linked articles at least three levels deep. By the time you are finished, you should have a very good answer to all your questions. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

---

Thanks for the reply Rajesh

---

]]>