Create View from 2 servers.

Hi,
Can we create a view from databases residing on different servers?
Thanks,
Harriet.yes, you can do that. Setup one server as a linked server on the other one and you can access objects in the linked server by using their full names (server.database.owner.objectname). See for more info on setting up a linked server in books online.|||hey, thanks a ton buddy. It was of great help.
Thanks once again

btw, do you have any idea as to how I would be able to run udfs on version 7.0?
Cheers!!
Hsm