SQL Server 2000 Solution Center

Top issues

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...
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.
The PRINT, RAISERROR, DBCC commands and the ODBC Driver for SQL Server 2000 and SQL Server 7.0
For the ODBC 3.5 x compliant SQL Server driver, messages from consecutive PRINT, RAISERROR, DBCC, or similar statements, as in a batch or stored procedure, are returned in a separate result set for each statement. With Microsoft SQL Server 6. x...

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: A Query That Uses a Large Search String in the CONTAINS Clause May Fail with Error Message 7607
If you use large search strings in the CONTAINS clause of a full-text query, you may receive the following error message: Msg 7607, Level 17, State 1 Search on full-text catalog (%s) for database ID (%d), table ID (%d) with search condition (%s)...
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.