January 17, 2007 at 4:30 am
Hi guys,
I have a scheduled job that contains the following statement.
INSERT INTO [BETSQL01\SQL2005].DBA_REPORTS.dbo.Database_Info
EXEC sp__databaseinfo
When I execute the stored procedure, i get no error. When i execute the whole statement, i get the following error.
Server: Msg 7391, Level 16, State 1, Line 1
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].
Can anyone pls help.
Regards,
January 17, 2007 at 5:19 am
either set XACT_ABORT on in your connection or use set distributed transaction on so that u wil be able to call the sql w/o errors.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
January 19, 2007 at 4:00 am
Hi Imke,
have u solved this problem. whats was done to solve this one. Please let us know.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply