error message in application

We updates the 2000 SQL Server to SP 4 and are getting the following error:
Application error: cannot go remote while the sessions is enlisted in a
distributed transaction that has an active savepoint
source: microsoft OLE DB Provider for Sql Server
Error code: -2147217900
Any ideas?
Thanks,
Linda
This was fixed by removing a named transaction from a stored procedure that
involved a distributed transaction. This didn't cause an error pre SP4,
although clearly BOL states you can't use named transactions for a
distributed transaction. That "bug" must have been fixed in SP4.
"lslmustang" wrote:

> We updates the 2000 SQL Server to SP 4 and are getting the following error:
> Application error: cannot go remote while the sessions is enlisted in a
> distributed transaction that has an active savepoint
> source: microsoft OLE DB Provider for Sql Server
> Error code: -2147217900
> Any ideas?
> Thanks,
> Linda