How can I code a view using a table on another server 1

[TommyTea]

I need to create a view in my database that uses a table in another database and on a different server.

 

[JamesLean]

Look up "linked servers" in BOL. After setting one up, just qualify the table names like this:

SELECT * FROM server.database.owner.table

--James

 

[TommyTea]

Thank you. that should do it.