Microsoft Knowledge Base Article Links

From the Database Community Forum

April 2004

Week Ending April 9 | April 16 | April 23 | April 30

Week Ending April 9, 2004

Microsoft Access

• You may receive an error message when you try to upsize your Access database by using the Upsizing Wizard
• Access 2000 post-Service Pack 3 hotfix package: March 24, 2004
• You may receive an error message when you try to save an edited record that is based on a multi-table view in Access
• Access 2003 hotfix package: March 17, 2004

MDAC (ADO, OLEDB, ODBC)

• FIX: Access violation occurs when you try to connect to a SQL Server server by using the Microsoft OLE DB Provider for SQL Server
• Release Manifest for MDAC 2.8 (2.80.1022.3)

SQL Server 2000

• FIX: Performance of a query that is run from a client program on a SQL Server SP3 database is slow after you restart the instance of SQL Server
• INF: Frequently Asked Questions - SQL Server 2000 - Server
• You may receive error message 8650 when you run a query that uses intra-query parallelism
• BUG: You cannot install SQL Server Desktop Engine on a computer that has an operating system locale that does not have a default SQL Server collation mapping
• PRB: SQL Server Comparisons Between Columns and Constants with Different Data Types
• INF: Comparing SQL Collations to Windows Collations
• How to transfer a database from one collation to another collation in SQL Server
• A Complex Query Is Not Successful on a Server That Has More Than 2 GB of Memory
• FIX: Intermittent query slowdowns and corresponding high CPU utilization
• FIX: Some queries that have a left outer join and an IS NULL filter run slower after you install SQL Server 2000 post-SP3 hotfix
• FIX: Issues That Are Resolved in SQL Server 2000 Patch SQL2000-KB810185-8.00.0859
• FIX: SQL Server Enterprise Manager quits unexpectedly when you modify a DTS package
• Why the SQL Server Optimizer Uses a Nonclustered Index Instead of a Clustered Index
• You may receive error messages when you use the CREATE DATABASE statement to create a SQL Server database
• FIX: A DML Operation on a Large Table Can Cause Performance Problems
• FIX: A Transact-SQL Statement That Is Embedded in the Database Name Runs with System Administrator Permissions
• How to manually remove a replication in SQL Server 2000
• FIX: A query that performs join operations between multiple tables may return incorrect results
• FIX: A Query That Causes Hash Role Reversal May Return Incorrect Results
• FIX: A query that references a view that uses UNION operator may return incorrect results
• FIX: The compile time for a query that uses at least one outer join may be greater for SQL Server post-SP3 builds
• FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000
• FIX: You receive an error message when you run a parallel query that uses an aggregation function or the GROUP BY clause
• FIX: MDX queries to cubes where real-time updates are enabled may not reflect updates to the relational table
• FIX: "Value can not be converted to requested type" error when you try to read a Real data type column from a JDBC ResultSet object
• How to manually activate a report server instance by using Rsactivate
• FIX: Improved SQL Manager Robustness for Odd Length Buffer
• FIX: A Parameterized UNION Query Inside a Stored Procedure Returns Incorrect Results
• FIX: You receive error message 3456 when you try to apply a transaction log to a server
• FIX: A memory leak may occur when you use the sp_OAMethod stored procedure to call a method of a COM object
• FIX: SQL Server Jobs That Are Owned by Non-sysadmin Users May Not Start
• FIX: The SQL Server cluster resource may be marked as Fail when you try to take it offline
• FIX: A Query That Causes a Hash Bailout May Return Incorrect Results
• FIX: SQL Server Might Take a Long Time to Recover After an Abrupt or Unexpected Server Shutdown
• FIX: Error Message 3628 May Occur When You Run a Complex Query
• You receive query results that were not expected when you use both ANSI joins and non-ANSI joins
• FIX: "Column index out of range" error when you try to read a field from a JDBC ResultSet object
• FIX: SQL Profiler Displays Incorrect TextData Value When You Run a Nested Stored Procedure by Using a Remote Procedure Call
• FIX: SQL Server May Generate an Incorrect SQL Script for a Table Constraint When You Use the "Generate SQL Script" Option in Enterprise Manager
• FIX: Rows are unexpectedly deleted when you run a distributed query to delete or to update a linked server table
• FIX: When you run a program or a Web browser script that uses the Command object in the ADO programming interface to run a SQL Server stored procedure, you may receive an "EXECUTE permission denied on object..." error message in SQL Server 2000
• BUG: Snapshot Failures Occur When You Use an Alternate Snapshot Folder or FTP and the First Article is Dropped from the Publication
• FIX: A linked server query fails with the error message "Statement(s) could not be prepared" in SQL Server 2000
• You may receive error message 8525 when you try to run a distributed transaction on an instance of SQL Server 2000 SP3
• FIX: sysindexes.statblob Column May Be Corrupted After You Run a DBCC DBREINDEX Statement
• FIX: The global variable @@ERROR may return an incorrect value after a remote procedure call
• FIX: Osql.exe May Not Run Batches As Fast As Other ODBC-Based Applications
• FIX: A SELECT statement that contains computed columns and invalid filter condition values may cause an access violation
• FIX: Lock Escalation on a Scan While an Update Query is Running Causes a 1203 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
• FIX: You Receive an Error 8623 Error Message When You Try to Run a Query That Has Multiple Correlated Subqueries
• FIX: Cursor Plans Are Not Removed From the Cache When Virtual Memory Depleted
• FIX: The Snapshot Agent may fail after you make schema changes to the underlying tables of a publication
• FIX: You receive an EXCEPTION_ACCESS_VIOLATION error message when you try to save a DTS package in SQL Server 2000
• Fix: An error in a remote procedure call does not roll back the local operation
• FIX: The Xp_readmail Stored Procedure Only Saves the Text of an Embedded Attachment
• FIX: An Access Violation Occurs During Compilation If the Table Contains Statistics for a Computed Column
• FIX: Users Can Control the Compensating Change Process in Merge Replication
• FIX: You Cannot Synchronize Between a Replication Publisher and a Replication Republisher
• FIX: You may receive an "Invalid object name..." error message when you run the DBCC CHECKCONSTRAINTS Transact-SQL statement on a table in SQL Server 2000
• FIX: Query on the sysmembers Virtual Table May Fail with a Stack Overflow
• FIX: An access violation or error 5180 occurs when you run a parallel query that includes a large IN clause
• FIX: You may receive a 913 error message if your query includes user-defined functions, derived tables, and JOINs
• FIX: "Connection is busy with results for another command" error message occurs when you run a linked server query
• FIX: Slow Execution Times May Occur When You Run DML Statements Against Tables That Have Cascading Referential Integrity
• FIX: A scan of each partition table may be performed when you run an UPDATE statement on the partitioning column of a partitioned view
• FIX: A Query with a LIKE Comparison Results in a Non-Optimal Query Plan When You Use a Hungarian SQL Server Collation
• FIX: Access violation when you trace keyset-driven cursors by using SQL Profiler
• FIX: The TextData column of the SP:StmtStarting event and the SP:StmtCompleted event displays the dynamic Transact-SQL statement even when the stored procedure is encrypted
• FIX: You may receive a 644 error message when you run concurrent transactions on a heap
• FIX: xp_readmail Returns NULL in the attachment Column If the Attachment's Type Is Message Format

top

Week Ending April 16, 2004

Microsoft Access

• How to Use a Query to Filter Unique Data
• Full-file version update may request Office source files
• Dialing rules are ignored when you use the AutoDialer feature in Access
• MS04-014: Vulnerability in the Microsoft Jet Database Engine could permit code execution

MDAC (ADO, OLEDB, ODBC)

• FIX: Application stops responding or behaves unexpectedly when you run a COM+ application that uses the Microsoft ODBC Driver for Oracle

SQL Server 2000

• FIX: The performance of a computer that is running SQL Server 2000 degrades when query execution plans remain in the procedure cache
• FIX: You may receive incorrect results when you run a query that contains a UNION ALL operator, a TOP clause, and an ORDER BY clause

top

Week Ending April 23, 2004

Microsoft Access

• GRAPH2000: Pattern Fills Do Not Print Well

MDAC (ADO, OLEDB, ODBC)

• FIX: Hotfixes are available for MDAC 2.7 Service Pack 1
• FIX: Memory leak occurs when you use the Advanced Data Tablegram persistence mechanism to persist a hierarchical recordset to a Stream object

SQL Server 2000

• BUG: You may not be able to connect to an instance of Microsoft SQL Server 2000 Desktop Engine SP3a or to an instance of Microsoft SQL Server 2000 Desktop Engine (Windows) after you enable the server network libraries
• BUG: You receive an "Unable to determine system default collation" error message when you try to remove Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server 2000 Desktop Engine (Windows)
• FIX: You may receive an access violation in the CRowsetTraceData::FGetNextRow function when you trace server activity with SQL Profiler

top

Week Ending April 30, 2004

Microsoft Access

• Text that is in a text box control of a report or a form may not appear correctly in Access
• You may receive a "Data cannot be retrieved from the source you have selected" error message when you try to start a wizard in Access
• Default values for the AllowZeroLength field properties and for the Indexed field properties that you create in Access 2002 or in Access 2003 may differ from earlier versions of Access
• BUG: A message does not appear in right-to-left reading order when you use the MsgBox function with the VbMsgBoxRtlReading constant

SQL Server 2000

• FIX: SQL Server underestimates the cardinality of a query expression and query performance may be slow
• FIX: The thread priority is raised for some threads in a parallel query
• How to troubleshoot connectivity issues in SQL Server 2000
• FIX: 8621 error conditions may cause SQL Server 2000 64-bit to close unexpectedly

top

Back to Microsoft Knowledge Base Links | Back to Database Community Forum

Alrak's Course Resources ©2002-2007 Karla Carter. All rights reserved. This material (including, but not limited to, Mini-lectures and Challenge Labs) may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. For permission, contact Karla.