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 |
imranabdulaziz
Yak Posting Veteran
83 Posts |
Posted - 2007-03-07 : 03:58:37
|
Dear All,i am making small web application using asp.net, C# ,sql2000.i have two different sqlserver. and two different table.i want to access or make select query form one server to other .how can i do it.that is i want a about regarding how to access view or table from other server to local server. i have base database where there is a view which need to access in my database of local server.that is how to make select query to access view in other server. Please helpthanks |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-07 : 04:02:08
|
1. you can do it from your application using a separate connection.2. or connect to one of the server and use linked server to access the other server.Refer to Books OnLine for details on linked server KH |
|
|
|
|
|