SQL Server 7.0 Solution Center

INF: Readpipe Return Codes
Two applications, Makepipe and Readpipe, are available to help diagnose problems creating and reading Named Pipes over the network. This article describes some of the more common return codes from the MS-DOS, Windows and Windows NT versions of these...
INFO: COM+ and MTS Always Use SERIALIZABLE Transaction Isolation Level
Database connections that are opened in transactional Microsoft Transaction Server (MTS) or COM+ 1.0 components are enlisted in the activity's Microsoft Distributed Transaction Coordinator (MS DTC) transaction. When COM+ enlists a connection in an MS...
How To Install an MSMQ Independent Client on a Cluster After SQL Server 7.0
If you try to install a Microsoft Message Queuing (also known as MSMQ) Independent Client (IC) or Routing Server (RS) on a Microsoft Cluster Server (MSCS) cluster where SQL Server 7.0 or later has been installed, the installation may fail because of...

FIX: Simultaneous DTC Operations May Cause Errors
SQL Server allows multiple system process ID (SPID) connections to enlist in the same Microsoft Distributed Transaction Coordinator (MS DTC) transaction. The SQL Server limits "active" operations to a single SPID. Simultaneous operation attempts...
FIX: Rollback of Bound Transaction May Cause Assertion Errors
Under rare conditions, when a bound transaction is rolled back, you may receive the following assertion failure error messages: Also, several of the following 3307 error messages may be logged in the SQL Server error log:
FIX: Abort of Command That Uses a Worktable May Result in Orphaned Extents in the Tempdb System Database
Aborting a command that has an open worktable may result in extents that are marked allocated in the Global Allocation Map (GAM) but that are not in use by any object. An example of this might be canceling the execution of a stored procedure that...

PRB: Cluster Group Containing SQL Server and MS DTC Moves Slowly
When moving a cluster group containing both Microsoft Distributed Transaction Coordinator (MS DTC) and SQL Server resources between nodes, it takes several minutes to take the resources offline and move the group to the other node. However, if the MS...
How To Reinstall MS DTC for a Nonclustered Windows NT 4.0 Server
This article describes how to reinstall Microsoft Distributed Transaction Coordinator (MS DTC) for a nonclustered server.
BUG: Merge Replication to Jet 4.0 Subscriber Does Not Allow You to Set the ROWGUIDCOL Column as a Primary Key Column
When you use merge publishing from Microsoft SQL Server to Jet 4.0, you cannot specify the uniqueidentifier column with the ROWGUIDCOL property as the primary key of the published table. Doing so, causes this error message to occur: