I am running some Data-Centric and User-Centric components in a COM+ application.

The Data-Centric components have Requires Transaction on them - they have the setcomplete and setabort in them

The user centric components do not. They do not call set complete and set abort - they just instantiate the data-centric components
and of course the data-centric components take care of the transactions - or so I thought !

I get this error .....

" [Microsoft][ODBC SQL Server Driver][SQL SERVER]Cannot use SAVE TRANSACTION within a distributed transaction "

I have a SAVE point in a transaction in a stored procedure and I suspect this is conflicting with COM+ transactions - is it possible in any way to have SAVE points in stored procedures being called by transactional COM+ Data Centric components???


Many many thanks !!!!