Partager via


SQL Server Kbs for February 2009

7

FIX: When you run an UPDATE statement against a table that has a FOR UPDATE trigger that joins the DELETED and INSERTED tables, the query takes a long time to finish

(967169) - Describes a problem that occurs when you run an UPDATE statement against a table that has a FOR UPDATE trigger that joins the DELETED and INSERTED tables, and the query takes a long time to finish. Includes a resolution.

- 2/17/2009 - https://support.microsoft.com/kb/967169

How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2005

(917825) - Describes the Sqldumper.exe utility that is included with SQL Server 2005. You can use this utility to generate different kinds of dump files.

- 2/6/2009 - https://support.microsoft.com/kb/917825

How to use Kerberos authentication in SQL Server

(319723) - Describes how to use Kerberos authentication in SQL Server, and how to enable Kerberos authentication on SQL Server failover clusters.

- 2/11/2009 - https://support.microsoft.com/kb/319723

The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released

(937137) - Lists the builds that were released after SQL Server 2005 Service Pack 2 (SP2) was released.

- 2/17/2009 - https://support.microsoft.com/kb/937137

SQL Server 2000 Desktop Engine (Windows) (WMSDE) is uninstalled when you use the "Add or Remove Programs" item in Control Panel to uninstall a security update for SQL Server 2000 and for MSDE 2000

(967093) - Describes a problem in which SQL Server 2000 Desktop Engine (Windows) (WMSDE) is uninstalled when you uninstall a specific security update for SQL Server 2000 and for MSDE 2000.

- 2/10/2009 - https://support.microsoft.com/kb/967093

The Windows Internal Database (WYukon) is removed when you use the Add or Remove Programs item in Control Panel to uninstall a security update for SQL Server 2005

(967095) - Describes a problem in which the Windows Internal Database (WYukon) is removed when you uninstall a certain security update for SQL Server 2005.

- 2/10/2009 - https://support.microsoft.com/kb/967095

Cumulative update package 12 for SQL Server 2005 Service Pack 2

(962970) - Describes cumulative update 12 for SQL Server 2005 Service Pack 2.

- 2/18/2009 - https://support.microsoft.com/kb/962970

ISA Server 2004 and ISA Server 2006 may be affected by the security updates in Microsoft Knowledge Base articles 960082 and 960083

(967094) - Describes issues that may occur when ISA Server 2004 and ISA Server 2006 may be affected by the security updates in Microsoft Knowledge Base articles 960082 and 960083.

- 2/10/2009 - https://support.microsoft.com/kb/967094

Asynchronous Disk I/O Appears as Synchronous on Windows NT, Windows 2000, and Windows XP

(156932) - File I/O on Microsoft Windows NT, Windows 2000, and Windows XP can be synchronous or asynchronous. The default behavior for I/O is synchronous: an I/O function is called and returns when the I/O is complete. Asynchronous I/O, on the other hand, allows...

- 2/6/2009 - https://support.microsoft.com/kb/156932

You cannot restore a database from a backup file when you use a SQL Server login ID that has the dbcreator server role to connect to an instance of SQL Server 2005

(950891) - Describes a problem in which you receive the "the Database Engine service could not resolve the specified file location" error message. Provides a workaround.

- 2/20/2009 - https://support.microsoft.com/kb/950891

You cannot apply security update 960082 in a Windows 2000 or Windows Server 2003 environment

(967092) - Describes an issue in which you cannot apply security update 960082 successfully in a Windows 2000 or Windows Server 2003 environment.

- 2/10/2009 - https://support.microsoft.com/kb/967092

SharePoint users are incorrectly offered a SQL Server 2000 Desktop Engine (Windows) update when they try to install the security update in Microsoft Knowledge Base article 960082

(967096) - Describes an issue that occurs when SharePoint users try to install the security update in Microsoft Knowledge Base article 960082, and they may incorrectly be offered a SQL Server 2000 Desktop Engine (Windows) update. Includes a resolution.

- 2/10/2009 - https://support.microsoft.com/kb/967096

Cumulative update package 2 for SQL Server 2005 Service Pack 3

(961930) - Describes cumulative update 2 for SQL Server 2005 Service Pack 3.

- 2/17/2009 - https://support.microsoft.com/kb/961930

FIX: The execution plan does not use the forced index when you use the INDEX optimizer hint in a query that runs against a synonym in SQL Server 2005

(963684) - Fixes an issue in which the INDEX optimizer hint is invalid when you use the INDEX optimizer hint in a query that runs against a synonym in SQL Server 2005.

- 2/17/2009 - https://support.microsoft.com/kb/963684

FIX: An empty result set is returned when you run an SSIS package that contains an Execute SQL task in SQL Server 2005 Service Pack 2

(967570) - Describes a problem that occurs when you run an SSIS package that contains an Execute SQL task in SQL Server 2005 SP2, and an empty result set is returned. Includes a resolution.

- 2/17/2009 - https://support.microsoft.com/kb/967570

FIX: The SQL Server service stops responding, and you receive error 1450 when you create database snapshot or run a DBCC CHECK statement on a database in SQL Server 2005

(967164) - Fixes an issue in which the SQL Server service stops responding and you receive error 1450 when you run a DBCC CHECK statement on a database in SQL Server 2005.

- 2/17/2009 - https://support.microsoft.com/kb/967164

FIX: You receive an error message when you try to query or update a column of large object (LOB) data in SQL Server 2005

(961648) - Describes a problem that occurs when you try to query or update a column of large object (LOB) data in SQL Server 2005. Provides a hotfix and an update.

- 2/17/2009 - https://support.microsoft.com/kb/961648

FIX: The values of some SQL Server 2005 SSIS pipeline counters are always 0 when you try to view them in a terminal session

(967316) - Describes a problem that occurs when you try to view the values of some SQL Server 2005 SSIS pipeline counters in a terminal session.

- 2/17/2009 - https://support.microsoft.com/kb/967316

FIX: You cannot kill a session that is running a query on a linked server in SQL Server 2005

(961237) - Fixes an issue in which you cannot kill a session that is running a query on a linked server in SQL Server 2005.

- 2/18/2009 - https://support.microsoft.com/kb/961237

FIX: Error message when you try to open a database file from a CD in SQL Server Compact 3.5 with Service Pack 1: "Internal Error using read only database file"

(959697) - Describes a problem that occurs when you try to open a database file from a CD in SQL Server Compact 3.5 with Service Pack 1, and you receive an error message. Includes a resolution.

- 2/26/2009 - https://support.microsoft.com/kb/959697

BUG: Database maintenance plan on system databases fails on integrity check if "Attempt to repair minor problems" is selected

(290622) - When the Attempt to repair any minor problems option is enabled, a database maintenance plan may fail when you run integrity checks on all the system databases and you receive the following error message:

- 2/5/2009 - https://support.microsoft.com/kb/290622

FIX: Error message when you apply a snapshot file that is exactly divisible by 1 MB in SQL Server 2005: "The process could not bulk copy into table dbo.<tablename>. (Source: MSSQLServer, Error number: 20253)"

(967527) - Describes a problem that occurs when you apply a snapshot file that is exactly divisible by 1 MB in SQL Server 2005.

- 2/17/2009 - https://support.microsoft.com/kb/967527

How to impede Windows NT administrators from administering a clustered instance of SQL Server

(263712) - Explains how you can impede Windows system administrators from having system administrator permissions in SQL Server Enterprise Edition.

- 2/13/2009 - https://support.microsoft.com/kb/263712

FIX: Error message when you run an UPDATE statement on a database that has the SNAPSHOT or READ COMMITTED SNAPSHOT isolation level enabled in SQL Server 2005: "The Database ID <Database ID>, Page (<N>:<N>), slot <N> for LOB data type node does not exist"

(962209) - Describes a problem that occurs when you run an UPDATE statement on a database that has the SNAPSHOT or READ COMMITTED SNAPSHOT isolation level enabled in SQL Server 2005, and you receive an error message. Includes a resolution.

- 2/17/2009 - https://support.microsoft.com/kb/962209

FIX: A query notification is not fired correctly if the query contains inner joins and the IS NULL clause in SQL Server 2005

(961935) - Provides a fix for an issue in which a query notification that is created for a query that contains inner joins and the IS NULL clause is not fired correctly in SQL Server 2005.

- 2/17/2009 - https://support.microsoft.com/kb/961935

How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port

(823938) - Describes static and dynamic TCP port allocation for an instance of SQL Server. Discusses how to configure an instance of SQL Server to use either a static port or a dynamic TCP port.

- 2/12/2009 - https://support.microsoft.com/kb/823938

You may not be able to connect to an instance of SQL Server by using an anonymous login

(839569) - Describes that anonymous connection attempts to an instance of SQL Server on a computer that is running Windows Server 2003 may not be successful. Includes a workaround for the problem.

- 2/12/2009 - https://support.microsoft.com/kb/839569

FIX: Error message when you synchronize data for a SQL Server Compact Edition subscriber in SQL Server 2005: "A call to SQL Server Reconciler failed. Try to resynchronize. HRESULT 0x80004005 (29006)"

(962003) - Fixes an issue in which you receive an error message when you synchronize data for a SQL Server Compact Edition subscriber in SQL Server 2005.

- 2/17/2009 - https://support.microsoft.com/kb/962003

FIX: An unresolved deadlock occurs when you perform an online reindex operation that runs on parallel threads in SQL Server 2005

(961479) - Fixes an issue in which a deadlock may occur when you perform an online reindex operation that runs on parallel threads in SQL Server 2005.

- 2/17/2009 - https://support.microsoft.com/kb/961479

How to move databases between computers that are running SQL Server

(314546) - Describes how to move databases between computers that are running SQL Server. Provides step-by-step information about the method.

- 2/12/2009 - https://support.microsoft.com/kb/314546

Error message when you use the SQL Server Error and Usage Reporting tool on a 64-bit Windows operating system: "The Error Reports Location path name cannot be empty"

(967598) - Describes an error message that you receive when you use the SQL Server Error and Usage Reporting tool on a 64-bit Windows operating system.

- 2/9/2009 - https://support.microsoft.com/kb/967598

After you execute the SqlCeEngine.Compact method against a SQL Server Compact 3.5 client database that is synchronized to a central database server, some changes to the client database may not be uploaded

(967502) - Describes that after you execute the SqlCeEngine.Compact method against a SQL Server Compact 3.5 client database, some changes to the client database may not be uploaded.

- 2/10/2009 - https://support.microsoft.com/kb/967502

MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009

(960089) - Describes the security update for SQL Server 2005 GDR that is dated February 10, 2009.

- 2/10/2009 - https://support.microsoft.com/kb/960089

MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009

(960090) - Describes the security update for SQL Server 2005 QFE that is dated February 10, 2009.

- 2/10/2009 - https://support.microsoft.com/kb/960090

MS09-004: Description of the security update for SQL Server 2000 QFE and for MSDE 2000: February 10, 2009

(960083) - Describes the security update for SQL Server 2000 QFE and MSDE 2000 that is dated February 10, 2009.

- 2/10/2009 - https://support.microsoft.com/kb/960083

MS09-004: Vulnerabilities in Microsoft SQL Server could allow remote code execution

(959420) - Resolves a vulnerability in SQL Server that could allow remote code execution if untrusted users have access to an affected system or if a SQL injection vulnerability exists on an affected system.

- 2/10/2009 - https://support.microsoft.com/kb/959420

SQL Server databases are not supported on compressed volumes

(231347) - Describes the reasons why Microsoft SQL Server databases are not supported on NTFS or FAT compressed volumes.

- 2/26/2009 - https://support.microsoft.com/kb/231347

FIX: Error message when you run a "LINQ to Entities" query that uses a string parameter or a binary parameter against a SQL Server Compact 3.5 database: "The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses"

(958478) - Fixes a problem in which you receive an error message when you run a "LINQ to Entities" query in an application that uses the Microsoft ADO.NET Entity Framework.

- 2/17/2009 - https://support.microsoft.com/kb/958478

Microsoft SQL Server Database Engine Input/Output Requirements

(967576) - SQL Server requires systems to support ‘ guaranteed delivery to stable media ’ as outlined under the Microsoft SQL Server Always-On Storage Solution Review program ( ). This requirement includes, but is not limited to: · Windows logo certification ·...

- 2/5/2009 - https://support.microsoft.com/kb/967576

FIX: Error message when you open Replication Monitor for a transactional publication in SQL Server 2005: "Initial snapshot for publication <PublicationName> is not available"

(967192) - Fixes an issue that occurs when you open Replication Monitor for a transactional publication or when you run the sp_replmonitorsubscriptionpendingcmds stored procedure on the distribution database.

- 2/17/2009 - https://support.microsoft.com/kb/967192

Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service

(942176) - Describes the role of the SSIS service and some limitations of clustering the SSIS service. Because of these limitations, we recommend that you cluster SQL Server Agent or update the MsDtsSrvr.ini.xml file on each node instead.

- 2/12/2009 - https://support.microsoft.com/kb/942176

The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance object" list after you install Integration Services from a 64-bit version of SQL Server 2005

(941154) - Explains that the "SQL Server:SSIS Pipeline" performance object is not available in System Monitor after you install SQL Server 2005 Integration Services from a 64-bit version of SQL Server 2005.

- 2/6/2009 - https://support.microsoft.com/kb/941154

Cumulative update package 8 for SQL Server 2005 Service Pack 2

(951217) - Describes cumulative update package 8 for SQL Server 2005 Service Pack 2.

- 2/2/2009 - https://support.microsoft.com/kb/951217

The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released

(960598) - Lists the builds that were released after SQL Server 2005 SP3 was released.

- 2/20/2009 - https://support.microsoft.com/kb/960598

FIX: Error message when you install Cumulative Update 10, Cumulative Update 9, or security update 954606 (security bulletin MS08-052) for SQL Server 2005 Service Pack 2 on a drive that uses the FAT32 file system: "Unexpected Error Occurred"

(959132) - Describes a problem that occurs when you install Cumulative Update 10, Cumulative Update 9, or security update 954606 (security bulletin MS08-052) on a FAT32 drive. Provides a hotfix.

- 2/12/2009 - https://support.microsoft.com/kb/959132

How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult

(932881) - Describes how to modify a SQL Server 2005 installation to make it more difficult for the operating system administrator to gain access to the instance of SQL Server 2005.

- 2/13/2009 - https://support.microsoft.com/kb/932881

The SQL Server service cannot start when you change a startup parameter for a clustered instance of SQL Server 2000 or of SQL Server 2005 to a value that is not valid

(912397) - Describes that the service of a clustered instance of SQL Server cannot start after you set an invalid protocol setting for the instance. Provides a method to work around this problem.

- 2/12/2009 - https://support.microsoft.com/kb/912397

MS09-004: Description of the security update for SQL Server 2000 GDR and for MSDE 2000: February 10, 2009

(960082) - Describes the security update for SQL Server 2000 GDR and MSDE 2000 that is dated February 10, 2009.

- 2/10/2009 - https://support.microsoft.com/kb/960082

Error message when you install SQL Server 2005 or SQL Server 2008: "The file C:\Windows\Microsoft.NET\Framework\[version_number]\mscorlib.tlb could not be loaded"

(918685) - Describes an issue where you receive an error message about the Mscorlib.tlb file when you install SQL Server 2005. Requires that you modify the registry to work around this issue.

- 2/12/2009 - https://support.microsoft.com/kb/918685

The use of third-party detours or similar techniques is not supported in SQL Server

(920925) - Explains that the use of third-party detours or similar techiques is not supported with SQL Server. Detours and similar techiques may cause significant problems.

- 2/19/2009 - https://support.microsoft.com/kb/920925

You may experience a decrease in query performance after you perform certain database maintenance operations or regular transaction operations in SQL Server 2005

(917828) - Describes an issue in SQL Server 2005 where you experience a decrease in query performance after you perform certain database maintenance operations or regular transaction operations.

- 2/17/2009 - https://support.microsoft.com/kb/917828