Error Running SQL Server Remote SP

[moueg]

I am trying to run the SQL statement below and having trouble. The error message I get is also below. I can run the execute statement by itself and get data returned.

This statement runs a procedure that is compiled on Server1 and inserts the output into a table also on Server1. The procedure itself references data on Server2.

Error Message:
Server: Msg 7391, Level 16, State 1, Procedure sp_JHP00001_BabyLog, Line 60
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].


SQL Statement:

INSERT INTO DB.dbo.TblName(
report_id,
report_period,
c_authorization_number,
c_cert_start_date,
c_cert_end_date,
c_req_number_units_sum,
auth_c_code,
auth_c_desc,
patient_name,
patient_id,
orig_dummy_id,
c_dob,
age_at_primary_dt,
c_gender,
c_group_id,
fac_c_provider_id,
fac_c_provider_name,
run_date,
auth_period_dt,
auth_period_txt,
c_network_id )
EXECUTE DB.dbo.sp_XXX '6/1/2004', '6/30/2004'

Thanks,
Moueg

 

[EBGreen]

I would recommend posting this question to one of the SQL fora.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]