|
|||||||
| SQL Course SQL Course > Ask questions about the lessons on SQL Course 1 and 2. If you have problems > with the interface, please post in the Feedback forum |
|
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
12-12-2002, 06:18 AM
|
|||
|
|||
How to select table data from different SQL Servers?
I have to access data between two SQL Servers(version 6.5), how to perform it?
|
|
#2
12-12-2002, 09:35 AM
|
|||
|
|||
|
In SQL 6.5 you can't directly access a table in another server while connecting to one.
But you can execute a stored procedure in another server and fetch data. To do this you need to setup remote logins in the remote server (see sp_addremotelogin in BOL). If you want to join tables from two servers in a query then only option is to connect to a SQL 7.0/2K server which has linked server configured to both SQL 6.5 servers.
|
|
#3
12-13-2002, 02:13 AM
|
|||
|
|||
|
Does it mean I can fetch table data on another server by executing a stored procedure on another server while connecting to one server? If yes, how to perform it?
|
|
|
«
Previous Thread
|
Next Thread
»
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
Linear Mode
|
|
All times are GMT -5. The time now is 07:10 AM.
 |
 |
 |
 |