>We have two servers (server1, server2). We are using server1 now. How can we select data from databse table in server2? and update tables in server1.
>
>Thanks
>
>Jim

Create a linked server. Look in the docs to see how to set this up. It is not to difficult.