Here’s a report on current Microsoft resources for SQL Server users, plus a list of Knowledge Base articles on the Microsoft site that contain SQL Server-related information.

TechNet SQL Server Technology Center Goes Online


The TechNet SQL Server Technology Center is a useful clearinghouse of resources to help you deploy, administrate, and manage SQL Server. Check out http://www.microsoft.com/ technet/sql/default.htm.

SQL Server Insider


Microsoft’s SQL Server News Web site at http://www.microsoft.com/ sql/news.htm has a new feature called SQL Server Insider (http://www.microsoft.com/sql/productinfo/news/insider.htm). This monthly feature lets SQL Server users discuss technical matters with the SQL Server developers. For example, the July forum topic was "SQL Server 7.0 Security Melds With Microsoft Windows NT," the August topic was "Simplicity Is The New Watchword for SQL Server 7.0," and the September topic was "English Query Helps Eliminate Report Creation Complexity." Microsoft archives past articles on the site.

Knowledge Base Watch


Here’s a list of new SQL Server-related Knowledge Base articles on the Microsoft site.

Q238206 BUG: Password Dangling and Decrypted When Changing Security Mode

Under certain circumstances, replication might decrypt the password for the SQL User account in the MSsubscriber_info table on a SQL Server 7.0 server. Fix available.
SQL Server
Q238146 BUG: Constraint Violation Not Detected If Update with Same Data

SQL Server 7.0 displays inconsistent behavior compared to version 6.5 and returns an error when you perform an update by setting a column value to itself against a table that contains a foreign-key constraint.
SQL Server
Q237707 BUG: SQL 6.5 Service Pack 5 (SP5) Setup Fails if Setup Path Has a DBCS Character

Running the SP5 Setup.exe in a directory that contains a double-byte character set (DBCS) character in the directory name might produce an error during the installation of the Distributed Transaction Coordinator.
SQL Server
Q237412 PRB: Quick Links from SQL Server 7.0 Support Highlights Page

SQL Server might not appear in the product list on the Support Highlights Page. This article describes a workaround.
SQL Server
Q237411 INF: SQL Server 7.0 Books Online (BOL) Points to Personal Support Page

BOL might incorrectly point you to the support page located at http://support.microsoft.com/support. This article describes a workaround.
SQL Server
Q236783 BUG: A Process May Stop Responding Several Seconds with Waittype

SQL Server 6.5 might let a multidatabase transaction wait for up to a minute under high-transaction loads. This article describes a workaround.
SQL Server
Q236447 BUG: ODS Errors During ATTN May Cause SQL Server to Stop Responding

SQL Server 6.5 might allow ODS error 17805 to hang processes and disallow new connections if it encounters the error while processing an attention signal. This article describes a workaround. A fix is available.
SQL Server
Q236443 BUG: SELECT DISTINCT Using Negative Int in WHERE Can Cause AV

SQL Server 7.0 might allow a handled access violation when it encounters a SELECT DISTINCT statement containing a large negative integer value in a clause of the WHERE statement. Fix available.
SQL Server
Q236439 BUG: Memory Leak with DB-Library Connection Using TCP/IP or IPX/SPX

SQL Server 7.0 might allow a persistent 4KB memory leak when it opens a DB-Library connection using the TCP/IP or IPX/SPX network libraries. Fix available.
SQL Server