After installing SP3 for SQL 2000, have been getting the following error when running some statements against a linked SQL 7.0 (SP4) server:
Server: Msg 8525, Level 16, State 1, Procedure <procname>, Line <linenum>
Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.
The linked server is SQL7.0 SP4. This error seems to only occur when the statement run from SQL2000 SP3 is contained in an explicit transaction like following:
SET XACT_ABORT ON
<some data modification statements (local or linked)>
<some more data modification statements (local or linked)>
The error does not occur if the BEGIN TRAN / COMMIT TRAN statements are removed.
MS Knowledgebase has a couple postings over the last two years describing similar problems, and both were supposedly resolved by "installing latest service pack" or "upgrading to latest MDAC". Since I'm running the 'latest' SP and MDAC appropriate for each of the two platforms involved, it would appear that this error has come back to life with the latest MDAC which is included in SQL2000 SP3.
The error does not occur if linked server is SQL2000 SP3.
I'm in the process of trying to put together a package for MS Support to reliably reproduce the error.
Has anyone else seen this after a SQL2000 SP3 upgrade?