Database

shouteye wrote:

whithout using time-consuming queries?

;WITH RecipientsByMail (MailId, RecipientList) AS (
    select mx.Id AS MailId , 
        (   select AddressTable.Name+','
            from MailTable
            join RecipientTable on RecipientTable.MailTableId = MailTable.Id
            join AddressTable   on AddressTable.Id = RecipientTable.AddressTableId
            WHERE MailTable.Id = mx.Id
            FOR XML PATH('')
        ) AS RecipientList 
    from MailTable as mx
)
select m.Id, m.Created, m.Subject, sender.Name, r.RecipientList
from MailTable as m
join SenderTable as s on s.MailTableId = m.Id
join AddressTable as sender on sender.Id = s.AddressTableId
join RecipientsByMail as r on r.MailId = m.Id ;

SELECT * FROM OPENQUERY(SERVER2, 'SELECT * FROM dbo.Shipments')

Mika Wendelius wrote:

Maybe catalog (or default database) has actual meaning only on OLEDB-queries?

EXEC sp_addlinkedserver @server ='TRW', @srvproduct = '', @provider = 'SQLOLEDB',
    @datasrc = '127.0.0.1', @location = NULL, @provstr = '', @catalog = 'trw_data'