how to make select query to access view in other server
-
Dear All, i am making small web application using asp.net, C# ,sql2000. 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 help thanks
regards imran khan
-
Dear All, i am making small web application using asp.net, C# ,sql2000. 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 help thanks
regards imran khan
Dear Mr. Imran Khan, Let me describe your problem. You have two sql server. You want to query from these two server. If this is your problem. then you can use Linked Server. You will get more information about this in http://www.sqlteam.com[^]
Mehedi Hasan
-
Dear Mr. Imran Khan, Let me describe your problem. You have two sql server. You want to query from these two server. If this is your problem. then you can use Linked Server. You will get more information about this in http://www.sqlteam.com[^]
Mehedi Hasan
THanks for quick reply. but your link only go to the site does not show topic. please guide me.
regards imran khan
-
Dear All, i am making small web application using asp.net, C# ,sql2000. 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 help thanks
regards imran khan