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
there are many ways to access other server.database.table
(a) Configure LinkedServer
b)OPENDATASOURCE
(c) OpenQuery
read about this in BOL
Madhu
No comments:
Post a Comment