I have an aspx file that calls a C# COM+ function that returns a
DataSet from a SQL Server 2000 SP4 database.

[Transaction(TransactionOption.Required)]

When I run the page locally, everything is fine.  

When I run it remotely, I get the
"System.Runtime.InteropServices.COMException (0x8004D00E): Exception
from HRESULT: 0x8004D00E" error.

When I run it remotely but change
[Transaction(TransactionOption.Required)] to
[Transaction(TransactionOption.Supported)], everything is fine.

My question: Why can't my object use transactions when referencing a
remote server?  I've spent the day researching and have found posts
from other users having the same problem, but no definite resolution.