• Assuming the tables you want to expose in a single view are all the same, have you tried something like this?

    CREATE VIEW BillsView

    AS

    SELECT field_list

    FROM [server,port].database_name.dbo.table_name

    UNION

    SELECT field_list

    FROM [server2,port2].database_name2.dbo.table_name;