SQL Server 2000 Solution Center

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...
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.
INF: Refresh of Current Activity in SEM May Cause "Error 1222: Lock Request time out period exceeded" Error Message
When you attempt to expand or refresh Current Activity in the SQL Enterprise Manager, you may receive this error message:

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.

PRB: Merge Replication to Jet 4.0 Subscribers May Fail During Process of Applying the Initial Snapshot
Merge replication to Jet 4.0 subscribers may fail during the process of applying the initial snapshot, with the following errors reported in the output file for the merge agent: These errors may be reported by the merge agent when it tries to apply...
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:
FIX: Merge Snapshot Generation Fails with Error Message: " Line 326: Incorrect Syntax near '-' if the Table Schema Contains a ROWGUID Column
If a table that is being merge published has a ROWGUID column, and the ROWGUID field is not the last column in the table, the initial snapshot generation for a merge publication may fail and the following errors are logged in the snapshot output file: