SQL Server 2000 Solution Center

Top issues

TechNet Support WebCast: Microsoft SQL Server 2000 Reporting Services Service Pack 2
Thursday, May 5, 2005: 10:00 AM Pacific time: Discuss software updates and new feature improvements included in the Service Pack 2 release of SQL Server 2000 Reporting Services.
Service Pack 3a for Microsoft SQL Server 2000 April 9, 2003
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...

FIX: SQL Mail 2000 Needs Microsoft Outlook 2000 Client
The SQL Mail feature of SQL Server 2000 does not work if Microsoft Outlook 2000 is not installed on the server that functions as the mail client. If Microsoft Outlook 2000 is not installed on the server that is the mail client and you attempt to...
FIX: MS DTC Transaction Commit Operation Blocks Itself
A Microsoft Distributed Transaction Coordinator (MS DTC) transaction commit operation may cause a blocking scenario on itself. In the SQL Server sysprocesses table output, the SQL Server process ID number (SPID) is less than 50 and shows a self block....
FIX: Bcp.exe ignores -R regional settings switch when using format file (-f)
Explains that Bcp.exe ignores the -R settings when the -f (format file) is specified.

Support WebCast: Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack Installation
Session Summary This is an entry-level walkthrough on the installation of a named-instance SQL Server 2000 virtual server. Topics covered will include: MS DTC installation on a server cluster; base SQL Server 2000 virtual server installation; virtual...
You receive an "A Microsoft Distributed Transaction Coordinator problem prevented connection to the Configuration database" error message when you publish assemblies from BizTalk Server 2004
Describes how to fix a problem that occurs when a user publishes an assembly from a computer that is running BizTalk Server 2004 and Microsoft Windows Server 2003.
Support WebCast: Microsoft SQL Server 2000 Windows CE Edition Overview and Programming
Session Summary This WebCast will focus on Microsoft SQL Server 2000 Windows CE Edition overview and programming. We will talk about SQL Server CE architecture, applications, connectivity solutions, and object models. This is a session that was recorded...