Accessing VIEW via SELECT statement from another server

[benchpolo]

Server1: A
View: v_test

Server2: B

Currently, I need to create the view from Server1 and query it from Server2. Question? How do i query v_test from server B via select statement?

Thanks

[ck9663]

Use this and this

-- CK

[dbpros]

Link the remote server and then refer to the view using server2.databas e.dbo.view syntax.

http://www.db-pros.com