Error 7391

Brief background... I have basically the same sql/db at
each of my locations and once a week I try to merge all of
the db into one corporate db. I have several queries that
are in a stored procedure that seem to be working just
fine but there is one query that just does not want to
work. I get the following messages...
INSERT INTO Invoice_MiscCharge (InvNo, MiscCharge,
UnitPrice, Qty, ExtendedPrice, WorkOrder)
SELECT Invoice_MC.InvNo, MiscCharge, UnitPrice, Qty,
ExtendedPrice, WorkOrder
FROM tmpInvoice INNER JOIN [D8J5ZH11\CASQL].
[EncompassCA].[dbo].[Invoice_MiscCharge] AS Invoice_MC
ON tmpInvoice.InvNo = Invoice_MC.InvNo
where tmpInvoice.invno=240530579
Server: Msg 8501, Level 16, State 1, Line 1
MSDTC on server 'D8J5ZH11\CASQL' is unavailable.
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 error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d01c].
If I run just the select part of the query it works just
fine but as soon as I add the insert it bombs. Even with
trying to insert just one record.
Check how to troubleshoot this error at
http://support.microsoft.com/default...b;en-us;306212 BTW, check if
your DTC service is runnin as well.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"David" <dagwin@.hotmail.com> wrote in message
news:1855201c44a5b$31568690$a501280a@.phx.gbl...
> Brief background... I have basically the same sql/db at
> each of my locations and once a week I try to merge all of
> the db into one corporate db. I have several queries that
> are in a stored procedure that seem to be working just
> fine but there is one query that just does not want to
> work. I get the following messages...
> INSERT INTO Invoice_MiscCharge (InvNo, MiscCharge,
> UnitPrice, Qty, ExtendedPrice, WorkOrder)
> SELECT Invoice_MC.InvNo, MiscCharge, UnitPrice, Qty,
> ExtendedPrice, WorkOrder
> FROM tmpInvoice INNER JOIN [D8J5ZH11\CASQL].
> [EncompassCA].[dbo].[Invoice_MiscCharge] AS Invoice_MC
> ON tmpInvoice.InvNo = Invoice_MC.InvNo
> where tmpInvoice.invno=240530579
>
> Server: Msg 8501, Level 16, State 1, Line 1
> MSDTC on server 'D8J5ZH11\CASQL' is unavailable.
> 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 error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d01c].
> If I run just the select part of the query it works just
> fine but as soon as I add the insert it bombs. Even with
> trying to insert just one record.
|||Thank you for the reference. I am taking a look at the
page. I guess what really has me stumped is the query
that is failing is the 5th query in the list. All the
other queries run against the same server/database but the
only thing that changes are the tables.
Thank you for the information
David

>--Original Message--
>Check how to troubleshoot this error at
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;306212 BTW, check if[vbcol=seagreen]
>your DTC service is runnin as well.
>--
>Dejan Sarka, SQL Server MVP
>Associate Mentor
>Solid Quality Learning
>More than just Training
>www.SolidQualityLearning.com
>"David" <dagwin@.hotmail.com> wrote in message
>news:1855201c44a5b$31568690$a501280a@.phx.gbl...
of[vbcol=seagreen]
that[vbcol=seagreen]
with
>
>.
>