Microsoft Knowledge Base Article Links
From the Database Community Forum
May 2004
Week Ending May 7, 2004
Microsoft Access
MDAC (ADO, OLEDB, ODBC)
- Passing ADODB::Field Object to ADO Command.CreateParameter Method Causes a Memory Leak
- FIX: Accessibility error occurs when you configure a UDL file on a computer that is running a 64-bit operating system
SQL Server 2000
- The NET SEND command may not work correctly on a computer that is running Windows XP Service Pack 2
- You may not be able to connect to an instance of SQL Server that is configured to use the Named Pipes server network library on a computer that is running Windows XP Service Pack 2
- FIX: A memory leak occurs in Analysis Services when a VBA function is used in a calculation
- Support WebCast: Middle-tier Applications and Analysis Services
- BUG: The changes in a remote subscriber are not updated to the publisher for a queued updating replication that uses Message Queuing on a computer that is running Windows XP Service Pack 2
Week Ending May 14, 2004
Microsoft Access
- You receive a "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later." error message when you try to open database objects in Access
- The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database
MDAC (ADO, OLEDB, ODBC)
SQL Server 2000
- How to enable SQL Server 2000 Reporting Services on Windows XP Service Pack 2
- FIX: The UserName function returns NULL or an empty string in an MDX query or in an MDX expression
- FIX: The Analysis Services service may shut down if the Cache Policy connection property's value is set to 7
- You receive an error message when you try to install the Hosted Exchange 2003 Plans Database Engine
- You receive an "A Microsoft Distributed Transaction Coordinator problem prevented connection to the Configuration database" error message when you publish assemblies from BizTalk Server 2004
- You may notice incorrect values for the "Active Transactions" counter when you perform multiple transactions on an instance of SQL Server 2000 that is running on an SMP computer
Week Ending May 21, 2004
Microsoft Access
SQL Server 2000
- How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server 2000
- How to enable SQL Server connectivity on Windows XP Service Pack 2
- FIX: A call to a RAISERROR statement in a Transact-SQL batch can cause a SQLAgent job to fail and to lose output in SQL Server
- Frequently asked questions - SQL Server 2000 - Tools
- How to set up a development environment from the MSDN Professional subscription
- How to install key products from the MSDN Enterprise subscription
- Blocking problems may occur when you use SQL Server Enterprise Manager to make design changes to a table
- How to publish a computer that is running SQL Server 2000 at a computer that is running ISA Server 2004
- FIX: You receive a "Failed to reserve contiguous memory of Size= " error message when you run a query that has many predicates that are a sql_variant data type in SQL Server 2000
- Your SQL Server Desktop Engine installation may stop responding when you use the WaitForSingleObject function in a Win32 bootstrap wrapper application
- How to debug full-text search when a 7608 (0x80004005) error message occurs in SQL Server
Week Ending May 28, 2004
Microsoft Access
- Description of the Access 2003 Danish Update: May 25, 2004
- You may receive "The feature you are trying to use is on a network resource that is unavailable" error message when you try to remove an Access 2003 runtime application from your computer
- Office 2000 post-Service Pack 3 hotfix package: May 13, 2004
- "There are no Office Assistant character files present" error message when you start an Office 2000 program for the second time
MDAC (ADO, OLEDB, ODBC)
- Release Manifest for MDAC 2.7 Refresh (2.70.9001.0)
- FIX: Dialup connection does not disconnect Microsoft SQL Server even after timeout expires
- FIX: Non-localized version of the sqlsrv32.dll file is installed during the installation of the MS03-033 security update
SQL Server 2000
- You may not be able to connect to an instance of SQL Server that is configured to use the TCP/IP server network library on a computer that is running Windows XP Service Pack 2
- You may receive a 7391 error message in SQL Server 2000 when you run a distributed transaction against a linked server after you install Microsoft Windows XP Service Pack 2
- The ORDER BY clause in views, derived tables, inline functions, and subqueries in SQL Server 2000
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.