You can use the concept of linked servers to achieve this. Essentially, you
will create a named reference to the other server from one server. Post that
you can access the server and its data by using a 4 part naming convention
like: Server.Database.User.Object. Check out the setting-up of linked
servers in SQL Server BOL.
Please reply to the whole group only!
"Niitmalad" <co.in> wrote in message