Chip,
More info would be helpful! Are you using a linked server to Oracle?

If so, see KB article 280106 (Q280106) "HOW TO: Set Up and Troubleshoot a
Linked Server to Oracle in SQL Server" at
http://support.microsoft.com/default.aspx?scid=kb;en-us;280106

If not, and if this is distributed transaction that is using MSDTC, ensure
that the MSDTC service is started and running and use:
DBCC traceon(3604,7300)
go
Begin distributed transaction

-- your query here

DBCC traceoff(3604,7300)
go

To capture more info on the exact error....
Regards,
John



[quoted text, click to view]