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.
|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.
|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.
|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.
|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.
|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.
|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.
|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.
|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.