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 |
|
Jster
Starting Member
21 Posts |
 Posted - 2006-11-09 : 13:57:23
|
| Is it possible to connect to two SQL Servers and pull the information from one and put it in the other. I just moved some tables from one sql server to another and now I have to figure out how to get the ASP Page to pull from one server and put it on another without going per record.Thanks,Josh |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-09 : 15:14:12
|
| Either use two connections in the ASP page, or if you want to be able to query both servers in a single query, create a linked server on the server that the ASP app will connect to (the linked server will be for the second server). Then connect to the first server and refer to tables on the second server using 4 part namesservername.databasename.ownername.tablenameSee Books Online for linked servers. |
 |
|
|
|
|
|
Two SQL Servers one Recordset