kbupdate.info ›
Daily Updated!
SQL Server 2005 articles, fixes and updates - April 2009
Daily Updated!
chronological list: 2010 | ... 11 10 9 8 7 6 5 4 3 2 1 | 2008/12 11 10 ... 2003
alphabetical list: A B C D E F G H I K L M N O P Q R S T U V W Y
This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2005 that have been released in April 2009. The list is daily updated.
- 137983 How to troubleshoot orphaned connections in SQL Server Q137983 KB137983 April 30, 2009
- 329204 General guidelines to use to configure the MAXDOP option Q329204 KB329204 April 28, 2009
- 970669 SQL Server 2008 specific folders are created on systems with SQL Server 2005 starting SP3 and above to prevent upgrade failures to SQL Server 2008 at a later time Q970669 KB970669 April 27, 2009
- 922672 Support policy for untested .NET Framework assemblies in the SQL Server 2005 CLR-hosted environment Q922672 KB922672 April 26, 2009
- 954593 MS08-052: Vulnerabilities in GDI+ could allow remote code execution Q954593 KB954593 April 25, 2009
- 968951 FIX: A SQL Server 2005-based application cannot connect to a mirrored database by using the JDBC driver 1.2 after the first successful connection Q968951 KB968951 April 23, 2009
- 969466 FIX: Error message when you run a query that uses the CASE function in SQL Server 2005: "Conversion failed when converting the <DateType> value '<Value>' to data type <DataType>" Q969466 KB969466 April 20, 2009
- 969142 FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: "Unable to deallocate a kept page" Q969142 KB969142 April 20, 2009
- 969123 FIX: Error message occurs unexpectedly at different times in a SQL Server 2005 Analysis Services database that uses user-defined functions: "The <Function Name> function does not exist" Q969123 KB969123 April 20, 2009
- 969021 FIX: A query that contains the IS NOT NULL clause returns an incorrect result in SQL Server 2005 Q969021 KB969021 April 20, 2009
- 968914 FIX: When you convert a TEXT column to a VARCHAR(MAX) column, an NTEXT column to a NVARCHAR(MAX) column, or an IMAGE column to a VARBINARY(MAX) column, the original NULL values in these columns may become empty strings in SQL Server 2005 Q968914 KB968914 April 20, 2009
- 968906 FIX: An access violation occurs when a peer-to-peer transactional replication is under stress in SQL Server 2005 Q968906 KB968906 April 20, 2009
- 968381 FIX: All records in the query log table are truncated when you synchronize a database in SQL Server 2005 Q968381 KB968381 April 20, 2009
- 968233 FIX: A SQL Server 2005 database becomes offline unexpectedly when you run an application that uses service broker on this database Q968233 KB968233 April 20, 2009
- 968079 FIX: Error message after you configure a peer-to-peer transactional replication and then apply SQL Server 2005 Service Pack 3: "The process could not allocate memory. (Source: MSSQL_REPL, Error number: MSSQL_REPL20001)" Q968079 KB968079 April 20, 2009
- 967984 FIX: When you process a full-text catalog in SQL Server 2005 and in SQL Server 2008, the operation stops responding Q967984 KB967984 April 20, 2009
- 967908 Cumulative update package 13 for SQL Server 2005 Service Pack 2 Q967908 KB967908 April 20, 2009
- 967625 FIX: Error message when you synchronize a database in SQL Server 2005 Analysis Services: "Errors in the metadata manager. The dimension with ID of '<Dimension ID>', Name of '<Dimension Name>' referenced by the '<Cube Name>' cube, does not exist" Q967625 KB967625 April 20, 2009
- 967618 FIX: Error message when you try to export a report to a PDF file in SQL Server 2005 Reporting Services: "Non-negative number required" Q967618 KB967618 April 20, 2009
- 967570 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 Q967570 KB967570 April 20, 2009
- 967527 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)" Q967527 KB967527 April 20, 2009
- 967348 FIX: Error message when you run a series of the CREATE SESSION CUBE statement and the DROP SESSION CUBE statement in SQL Server 2005 Analysis Services: "An unexpected exception occurred" Q967348 KB967348 April 20, 2009
- 967316 FIX: The values of some SQL Server 2005 SSIS pipeline counters are always 0 when you try to view them in a terminal session Q967316 KB967316 April 20, 2009
- 967199 FIX: The Wmiprvse.exe host process stops responding when you run a SQL Server 2005-based application that sends a Windows Management Instrumentation (WMI) query to the SQL Server WMI provider Q967199 KB967199 April 20, 2009
- 967192 FIX: Error message when you open Replication Monitor for a transactional publication in SQL Server 2005: "Initial snapshot for publication <PublicationName> is not available" Q967192 KB967192 April 20, 2009
- 967169 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 Q967169 KB967169 April 20, 2009
- 967101 FIX: The performance of database mirroring decreases when you run a database maintenance job that generates a large number of transaction log activities in SQL Server 2005 Q967101 KB967101 April 20, 2009
- 962903 FIX: The population process stops responding when you create an additional full-text catalog in SQL Server 2005 Q962903 KB962903 April 20, 2009
- 961704 FIX: The SQL Server Writer Service is not listed in the results when you run the Volume Shadow Copy Service administrative command-line tool on a server that has SQL Server 2005 installed Q961704 KB961704 April 20, 2009
- 961396 FIX: When you insert a string to a table by using the SQL Native Client (SNAC) OLE DB provider or the SNAC ODBC provider in a SQL Server 2005-based application, the string is truncated Q961396 KB961396 April 20, 2009
- 961237 FIX: You cannot kill a session that is running a query on a linked server in SQL Server 2005 and in SQL Server 2008 Q961237 KB961237 April 20, 2009
- 934749 FIX: Error message when you try to install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 from the existing active node: "The product instance <InstanceName> has been patched with more recent updates" Q934749 KB934749 April 20, 2009
- 962003 FIX: Error message when you synchronize data for a SQL Server Compact Edition subscriber in SQL Server 2005 and in SQL Server 2008: "A call to SQL Server Reconciler failed. Try to resynchronize. HRESULT 0x80004005 (29006)" Q962003 KB962003 April 16, 2009
- 961935 FIX: A query notification is not fired correctly if the query contains inner joins and the IS NULL clause in SQL Server 2005 and in SQL Server 2008 Q961935 KB961935 April 16, 2009
- 961920 FIX: A syntax error occurs when you try to use the lift chart to validate a mining model that uses an Oracle data source in SQL Server 2005 Analysis Services and in SQL Server 2008 Analysis Services Q961920 KB961920 April 16, 2009
- 961648 FIX: You receive an error message when you try to query or update a column of large object (LOB) data in SQL Server 2005 and in SQL Server 2008 Q961648 KB961648 April 16, 2009
- 961282 FIX: Error message when you try to display a report in SQL Server 2008 Management Studio: "System.IndexOutOfRangeException: Index was outside the bounds of the array" Q961282 KB961282 April 16, 2009
- 961146 FIX: You cannot connect to an instance of SQL Server 2005 Analysis Services or to an instance of SQL Server 2008 Analysis Services through HTTP when you configure Internet Explorer to use a .pac file Q961146 KB961146 April 16, 2009
- 968749 SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed Q968749 KB968749 April 14, 2009
- 833770 Support for SQL Server on iSCSI technology components Q833770 KB833770 April 14, 2009
- 960543 FIX: SQL Server 2005 or SQL Server 2008 may stop responding when you are performing a backup Q960543 KB960543 April 10, 2009
- 944390 FIX: Error message when you connect to a named instance of SQL Server on a client computer that is running Windows Vista or Windows Server 2008: "Specified SQL server not found" or "Error Locating Server/Instance Specified" Q944390 KB944390 April 8, 2009
- 321185 How to identify your SQL Server version and edition Q321185 KB321185 April 8, 2009
- 969962 Various memory errors are logged to SQL Server error log when using SQL CLR objects Q969962 KB969962 April 7, 2009
- 959026 FIX: Error message when you run a DB2 query that uses the WITH UR query hint in SQL Server 2005 Analysis Services and in SQL Server 2008 Analysis Services: "OLE DB error: OLE DB or ODBC error: An unexpected token "WITH" was found following "<Query>"" Q959026 KB959026 April 7, 2009
- 959025 FIX: Error message when you call a stored procedure that returns a rowset which has the DBPROP_MAXROWS rowset property or the SSPROP_MAXBLOBLENGTH rowset property specified: "The incoming tabular data stream (TDS) protocol stream is incorrect" Q959025 KB959025 April 7, 2009
- 959001 FIX: The Log Reader Agent skips some transactions when the Log Reader Agent runs to replicate transactions for a transactional replication in SQL Server 2005 and in SQL Server 2008 Q959001 KB959001 April 7, 2009
- 953991 FIX: The size of a database keeps increasing when you perform many DELETE operations and many INSERT operations on the database in SQL Server 2005 Q953991 KB953991 April 7, 2009
- 914288 How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server 2005 and in SQL Server 2008 Q914288 KB914288 April 7, 2009
- 968398 FIX: The SQL Server 2005 Analysis Services service crashes when you process dimensions in a cube that contains a calculation script by using the Process Update option Q968398 KB968398 April 3, 2009
- 947989 You cannot install SQL Server 2005 Service Pack 2 when the database file of the Resource database is not in the same folder as the log file of the Resource database Q947989 KB947989 April 3, 2009
- 263712 How to impede Windows NT administrators from administering a clustered instance of SQL Server Q263712 KB263712 April 3, 2009
- 968171 FIX: Error message when you try to create an encrypted database in SQL Server 2005 Compact Edition: "The operating system does not support encryption" Q968171 KB968171 April 2, 2009
- 961073 FIX: Error message when you run a DML statement in a LINQ to SQL application in SQL Server 2008: "The target table '<Table Name>' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause" Q961073 KB961073 April 2, 2009