Dear All,
We have an application which uses SQL Server 2000 Service pack 2 as backend. Our application merges data to various table as part of merge process. The data to be merged is placed in an XML file. When the size of the file exceeds certain limit, SQL Server 2000 throws the following error.
*** Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. ***
*** A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 1 - I/O Error detected in read/write operation) ***
Also this error comes only in SQL Server 2000. If we try to merge this in SQL Server 2005, then this error does not appear. The merge is successfull.
Is there any settings in SQL Server 2000, which should be made before merging data?
Thanks in Advance.