SQL Server 2008 articles, fixes and updates

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2008 that have been released in January 2010. The list is daily updated.

976379 FIX: A performance issue occurs when you perform a partition merge operation to move data between partitions in SQL Server 2008 Q976379 KB976379 January 29, 2010
2002452 The formatting of the columns is incorrect when using Excel to view csv file attachments sent from SQL Server's Database Mail Q2002452 KB2002452 January 28, 2010
978020 FIX: Only the first 2000 characters are returned by the fn_get_audit_file() function when you use it to obtain information from an audit file in SQL Server 2008 Q978020 KB978020 January 25, 2010
976899 FIX: A slipstream installation of SQL Server 2008 fails intermittently Q976899 KB976899 January 21, 2010
2009212 You are not able to browse SharePoint pages in non-default zone after uninstalling Reporting Services add-in Q2009212 KB2009212 January 19, 2010
977813 A version of Microsoft SQL Server 2008 Express that supports the .NET Framework 4 Beta 2 is available at Microsoft Download Center Q977813 KB977813 January 19, 2010
978904 FIX: An MDX query returns an incorrect result when it uses multiple nested calculations and custom rollups in SQL Server 2008 Analysis Services Q978904 KB978904 January 18, 2010
978851 FIX: The -R parameter is ignored when you use the BCP.exe utility together with the -R parameter and the -F parameter in SQL Server 2005 or in SQL Server 2008 Q978851 KB978851 January 18, 2010
978636 FIX: Error message when you render an SSRS 2008 report that has a matrix in a list: "Index was outside the bounds of the array" Q978636 KB978636 January 18, 2010
978504 FIX: An insert operation fails when you insert data from one database into another database when the destination database contains a user-defined data type in SQL Server 2008 Q978504 KB978504 January 18, 2010
978301 FIX: All CPU resources are used when you use Connector for SAP BI in an SSIS 2008 package Q978301 KB978301 January 18, 2010
978250 FIX: Deadlocks may occur when you run multiple jobs concurrently to rebuild indexes offline in SQL Server 2008 Q978250 KB978250 January 18, 2010
978154 FIX: The DROP SET command fails after some connections to some local cubes are closed in SSAS 2008 Q978154 KB978154 January 18, 2010
978108 FIX: Some nTEXT, NTEXT, or IMAGE data whose size is not greater than 80 bytes cannot be replicated correctly in a transactional replication after you upgrade SQL Server 2000 to SQL Server 2008 Q978108 KB978108 January 18, 2010
978070 FIX: The Measures.<X>.Dim folder is created unexpectedly when you use a non-admin user account to browse a cube in SQL Server 2008 Analysis Services Q978070 KB978070 January 18, 2010
977889 FIX: Error message when you try to run an SSIS 2008 package that contains a Flat File source and a text qualifier uses some special characters that are not supported by the W3C XML language specification: "An invalid character was found in text content" Q977889 KB977889 January 18, 2010
977842 FIX: An access violation occurs when you run the SET FMTONLY statement to set the value of the FMTONLY option to ON and a SQL Server 2005 or SQL Server 2008 server is under memory pressure Q977842 KB977842 January 18, 2010
977450 FIX: Error message when you run a query that uses a common table expression to shred XML data in SQL Server 2005 or in SQL Server 2008: "Internal Query Processor Error: The query processor could not produce a query plan" Q977450 KB977450 January 18, 2010
977309 FIX: A SSAS 2005 or SSAS 2008 server crashes when you run a Multidimensional Expressions query that uses the CDBL function in a calculated member Q977309 KB977309 January 18, 2010
977151 FIX: Error message when you add a subscription to a republisher that is in a merge publication in SQL Server 2005 or in SQL Server 2008: “Cannot create the subscription because the subscription already exists in the subscription database” Q977151 KB977151 January 18, 2010
977109 FIX: After you run the merge agent during the initialization of the subscription in SQL Server 2008, the ident_current() function returns a value that is larger than expected Q977109 KB977109 January 18, 2010
977097 FIX: Error message when you make a DDL change to an IDENTITY column and then synchronize the change to the subscriber in SQL Server 2008: "Incorrect syntax near the keyword 'IDENTITY' (Source: MSSQLServer, Error Number: 156)" Q977097 KB977097 January 18, 2010
977076 FIX: Error message when you run an ALTER INDEX statement on a table that has CDC enabled in SQL Server 2008: "Msg 22983: The unique index <Index Name> on source table <Table Name> is used by Change Data Capture" Q977076 KB977076 January 18, 2010
977066 FIX: Row headers are not displayed on some pages of an SSRS 2008 report when you click "Print Layout" to preview the report or when you export the report Q977066 KB977066 January 18, 2010
976991 FIX: The LogReader agent unexpectedly consumes all CPU resources when the agent handles a failed connection in a SQL Server 2008 transactional replication Q976991 KB976991 January 18, 2010
976974 FIX: You are continuously prompted for credentials when you use Business Intelligence Development Studio to deploy a SQL Server 2005 Reporting Services or SQL Server 2008 Reporting Services report Q976974 KB976974 January 18, 2010
976691 FIX: An access violation occurs intermittently when you run an application that uses SQL Server 2005 service broker or SQL Server 2008 service broker Q976691 KB976691 January 18, 2010
976565 FIX: A query that opens a cursor in an inline table-valued function or a view returns an incorrect result in SQL Server 2005 or in SQL Server 2008 Q976565 KB976565 January 18, 2010
976410 FIX: Performance issues occur when the join predicate in your query has outer reference columns in SQL Server 2005 or in SQL Server 2008 Q976410 KB976410 January 18, 2010
975991 FIX: The DBCC CHECKFILEGROUP statement does not check a partitioned object if one of the partitions is not presented in the filegroup being checked in SQL Server 2008 Q975991 KB975991 January 18, 2010
975950 FIX: Error message when you run an SSIS 2005 or SSIS 2008 package that uses the IBM DB2 OLE DB provider to export data to an IBM DB2 server: "The number of failing rows exceeds the maximum specified. Out of memory" Q975950 KB975950 January 18, 2010
975825 FIX: A row is not deleted at a subscriber when you delete a row at the publisher and then perform synchronization in a SQL Server 2005 or SQL Server 2008 merge replication Q975825 KB975825 January 18, 2010
975058 FIX: Connector 1.0 for SAP BI throws an exception when data is being loaded in parallel in a SSIS 2008 package Q975058 KB975058 January 18, 2010
974749 FIX: The last character of a char column or an nchar column is incorrectly replaced by a space character (char(32)) after a conflict is resolved by a customized conflict resolver in SQL Server 2005 or in SQL Server 2008 Q974749 KB974749 January 18, 2010
973785 FIX: Membership is not scripted in the predefined database roles after you script a database and enable the "Script object-level permissions" option in SQL Server 2005 or in SQL Server 2008 Q973785 KB973785 January 18, 2010
973357 FIX: Setup of SQL Server 2008 fails when the setup binary files are located in a folder whose path is in the 8.3 compatible format Q973357 KB973357 January 18, 2010
2011690 Updating a SQL Server 2008 cluster may fail on Cluster_IsOnlineIfClustered rule when using WSUS. Q2011690 KB2011690 January 12, 2010
2011889 Error Setup failed to validate specified Reporting Services Report Server occurs when you install Microsoft Dynamics CRM Q2011889 KB2011889 January 8, 2010
2011887 Error: The request failed with HTTP status 401: Unauthorized when you open a report in Microsoft Dynamics CRM 4.0 Q2011887 KB2011887 January 8, 2010
2009217 You are not able to reference a user defined data type that is defined in model database in tempdb Q2009217 KB2009217 January 6, 2010

SQL Server 2008 articles, fixes and updates - January 2010