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