|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
|
||||
|
||||
|
Selecting from table on remote server
How can I run a select statement on a remote server?
What I'm trying to do is populate a table with information from tables on another server. I know I can set up a DTS package to copy entire tables from one database to another, and schedule that to run at certain times. I would like to avoid that since I need the updates to be real time, not last nights version of the table. |
|
#2
|
|||
|
|||
|
I suggest putting this into a view:
SELECT * FROM OPENQUERY(MYSERVER, 'SELECT name, id FROM titles') |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Selecting from table on remote server |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|