An application that uses the ADO interface may malfunction, or data loss may occur when the application connects to SQL Server in Windows Vista, in Windows XP, or in Windows Server 2008

Consider the following scenario:

• An application connects to one of the following products:
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2000
  • SQL Server Desktop Engine (also known as MSDE 2000)
• The application uses the SET NOCOUNT ON statement for the connection.
• The application uses a Microsoft ActiveX Data Objects (ADO) client-side cursor to insert a row into a table that has an identity column.

When the application queries the identity column value of the newly inserted row, the value "0" is returned incorrectly. When this value is returned, an application that uses the ActiveX Data Objects (ADO) interface may malfunction, or data loss may occur. Whether a malfunction or data loss occurs depends on how the application handles this scenario.

Note This problem occurs only if the application uses a client-side cursor. If the application uses a server-side cursor, the application is not affected.

This problem occurs in the Microsoft Data Access Components (MDAC) components of the following Windows operating systems:

• Windows Vista Service Pack 1 (SP1)
• Windows XP Service Pack 2 (SP2) with hotfix 940569
• Windows XP Service Pack 3 (SP3)
• Windows Server 2008

Update information for Windows Vista and for Windows Server 2008

Update information

The following files are available for download from the Microsoft Download Center:
Download the update for Windows Vista (KB952287) package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=3D822833-83E3-4D06-9807-06EF573BC168)
Download the update for Windows Vista for x64-based Systems (KB952287) package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=19A1EE14-FC82-4127-AFD7-76CCF732D6E3)
Download the update for Windows Server 2008 (KB952287) package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=CFF5FBF5-9AAC-48C1-B34E-992224CE8B83)
Download the update for Windows Server 2008 for Itanium-based Systems (KB952287) package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=1B056EFC-46E0-4D1E-B8E2-870B720AFE11)
Download the update for Windows Server 2008 x64 Edition (KB952287) package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=7E292B47-6AAC-413E-BBD6-C822B43D47A8)

Prerequisites

To apply this update, the computer must be running one of the following operating systems:

• Windows Vista
• Windows Vista SP1
• Windows Server 2008

Restart requirement

You do not have to restart the computer after you apply this update.

Update replacement information

This update replaces the following hotfix:

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

Windows Vista SP1 or Windows Server 2008, x86-based versions

Windows Vista SP1 or Windows Server 2008, x64-based versions

Windows Vista SP1 or Windows Server 2008, Itanium-based versions

Update information for Windows XP

Update information

The following files are available for download from the Microsoft Download Center:
Download the update for Windows XP (KB952287) package now. (http://www.microsoft.com/downloads/details.aspx?FamilyId=C8EFA6E3-D1A5-4222-865B-421A0DF2BE26)

Prerequisites

To apply this update, you must have Windows XP SP2 or Windows XP SP3 installed on the computer.

Restart requirement

You do not have to restart the computer after you apply this update.

Hotfix replacement information

This update replaces the following hotfix:

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

Windows XP SP2, x86-based versions

Windows XP SP3, x86-based versions

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

This problem affects you if you use Retail Management System (RMS) Store Operations or Headquarters in Microsoft Dynamics on the Windows operating systems that are affected and that are supported. We recommend that you apply this hotfix to prevent invalid data or data loss.

For more information, click the following article number to view the article in the Microsoft Knowledge Base: For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base: