I'm receiving the following error:

Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
The transaction active in this session has been committed or aborted by another session.

I've read the information at the following links:

http://support.microsoft.com/default...b;en-us;329332

http://support.microsoft.com/?id=817064

Neither worked.

My configuration is Windows Server 2003 SP1 and SQL Server 2000 SE SP3a.

I was able to get the linked server statement to work if I select "No Authentication Required" under "Transaction Manager Communication" within MSTDC of Component Services. However the "No Authentication Required" scares me a bit.

Here's my code.

CREATE TABLE [dbo].[Email] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Originator] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Date Received] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Recipients] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CC List] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BCC List] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Subject] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Message] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Unread] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Attachments] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Message ID] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Insert Into Email
Exec SQL6.master.dbo.xp_readmail @peek='true', @suppress_attach='true'
GO

Any thougths?

Thanks, Dave