making a view from the other server

hi

I have two sql servers in the LAN, one is 2000 and the other is 2005. in 2005 server I have a database and I want to have a view of a table in a database in the other server (2000) is it possible?

thank you in advance

Did you used Linked servers (see Books Online) ?

|||

thank you for your answer,I will check but what should I do if they are not

|||another way is OPENROWSET but if this table is importan i should think to import it periodically depends on your business logic|||Just in case you are hitting brick wall of errors with linked server, refer to http://blogs.msdn.com/sqltips/archive/2005/06/07/426578.aspx