• hi,

    in SQL you can reference to each object using a 4-part name: [Server].[Database].[Schema].[Table]

    [Server] has to be registered as a Linked Server, for details have a look at books online (http://msdn.microsoft.com/en-us/library/ms190479.aspx)

    Depending on the amount of data the table on the other servers contain and the kind of view you might create (using joins over several servers) the peformance might be very poor.

    Depending on what you actually have on data and what you actually need there might be other solutions than views...