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 starts with letter F that have been released. The list is daily updated.

2121407 FIX: Error message when you use the sqlcmd utility to execute the Transact-SQL query in SQL Server 2008 and SQL Server 2008 R2 Q2121407 KB2121407 July 30, 2024
2455009 FIX: Slow performance when you recover a database if there are many VLFs inside the transaction log in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2455009 KB2455009 October 18, 2022
2446036 FIX: MOF compilation errors occur and Setup fails for SQL Server 2008 or SQL Server 2008 R2 Q2446036 KB2446036 October 18, 2022
982857 Fix: Distribution Agent fails with error code 20598 when a publication database is configured with the Read Committed Snapshot option Q982857 KB982857 October 18, 2022
2640027 FIX: SQL Server Agent job fails if you set the job schedule type as "Start automatically when SQL Server Agent starts" in SQL Server 2008 SP2, SQL Server 2008 SP3, SQL Server 2008 R2 SP1 or SQL Server 2008 R2 SP2 Q2640027 KB2640027 February 24, 2021
3135852 FIX: The encrypted endpoint communication with TLS 1.2 fails when you use SQL Server Q3135852 KB3135852 January 26, 2021
3030352 FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server database Q3030352 KB3030352 January 26, 2021
3027857 FIX: Error 832 occurs after you apply update MS14-044 to SQL Server 2008 R2 or SQL Server 2008 Q3027857 KB3027857 January 26, 2021
2994310 FIX: Distribution Agent for Oracle subscription fails when you use SQL Server 2008 R2 or SQL Server 2008 Q2994310 KB2994310 January 26, 2021
2967240 FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL Server Q2967240 KB2967240 January 26, 2021
2966114 FIX: Incorrect results when you run a full-text search on a phrase that contains a hyphen in SQL Server 2008 Q2966114 KB2966114 January 26, 2021
2963658 FIX: The TDE enabled database stops responding indefinitely on WRITELOG or LOGBUFFER wait in SQL Server Q2963658 KB2963658 January 26, 2021
2963408 FIX: Error 5180 occurs when you query BLOB column data in SQL Server Q2963408 KB2963408 January 26, 2021
2936984 FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server Q2936984 KB2936984 January 26, 2021
2927325 FIX: Thesaurus expansion for phrases returns unexpected results in SQL Server 2008 or SQL Server 2008 R2 Q2927325 KB2927325 January 26, 2021
2926699 FIX: Operating system version information that is returned from SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012 is incorrect in Windows 8.1 Q2926699 KB2926699 January 26, 2021
2926217 FIX: Performance problems occur when database lock activity increases in SQL Server Q2926217 KB2926217 January 26, 2021
2923837 FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server Q2923837 KB2923837 January 26, 2021
2921630 FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS Q2921630 KB2921630 January 26, 2021
2919611 FIX: "Installer terminated prematurely" error when you install SQL Server 2008 SP3 or SQL Server 2008 R2 SP2 Q2919611 KB2919611 January 26, 2021
2892741 FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012 Q2892741 KB2892741 January 26, 2021
2887465 FIX: You receive an incorrect result when you run a query that uses some ranking functions in SQL Server 2008 Q2887465 KB2887465 January 26, 2021
2884888 FIX: Unable to click OK or Cancel in the query designer in BIDS 2008 or in SQL Server 2008 Report Builder Q2884888 KB2884888 January 26, 2021
2878968 FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server Q2878968 KB2878968 January 26, 2021
2877204 FIX: Error 8985 when you run the "dbcc shrinkfile" statement by using the logical name of a file in SQL Server 2008 R2 or SQL Server 2008 Q2877204 KB2877204 January 26, 2021
2861939 FIX: Cannot uninstall, repair, add new features to, or add a new instance to SQL Server 2008 or SQL Server 2008 R2 in Windows 8 Q2861939 KB2861939 January 26, 2021
2859713 FIX: "The decryption key is incorrect" error when you open a symmetric key that is encrypted by an asymmetric key in SQL Server 2008, SQL Server 2012 or SQL Server 2008 R2 Q2859713 KB2859713 January 26, 2021
2844196 FIX: Not all results are returned when you perform a full-text search in SQL Server 2008 or SQL Server 2008 R2 Q2844196 KB2844196 January 26, 2021
2828205 FIX: SQL Server may freeze when an instance of SQL Server 2012, SQL Server 2008 or SQL Server 2008 R2 is shut down Q2828205 KB2828205 January 26, 2021
2821836 FIX: Incorrect result when you run an MDX query that returns multiple calculated members in SSAS 2008, SSAS 2012 or SSAS 2008 R2 Q2821836 KB2821836 January 26, 2021
2820952 FIX: Query on a role-playing dimension returns incorrect results in SSAS 2008, SSAS 2012 or SSAS 2008 R2 Q2820952 KB2820952 January 26, 2021
2819662 FIX: SQL Server performance issues in NUMA environments Q2819662 KB2819662 January 26, 2021
2812884 FIX: Index size increases significantly after you rebuild the index online and the RCSI is enabled in SQL Server 2008 or in SQL Server 2008 R2 Q2812884 KB2812884 January 26, 2021
2809431 FIX: Heap corruption occurs when an MDX error message is generated in SSAS 2008, SSAS 2008 R2 or SSAS 2012 Q2809431 KB2809431 January 26, 2021
2803994 FIX: Data corruption occurs when LOB data is loaded into a Transact-SQL variable in SQL Server 2008 R2, SQL Server 2012 or SQL Server 2008 Q2803994 KB2803994 January 26, 2021
2803799 FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2, SQL Server 2008 or SQL Server 2012 Q2803799 KB2803799 January 26, 2021
2802244 FIX: Installation or upgrade process fails when you install or upgrade a SQL Server 2008 clustered instance on mount points Q2802244 KB2802244 January 26, 2021
2791745 FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008 or in SQL Server 2012 Q2791745 KB2791745 January 26, 2021
2780146 FIX: "Incorrect syntax near 'IDENTITY_VALUE'" error when you try to decrypt data that is migrated from another database in SQL Server 2008 R2, SQL Server 2012 or in SQL Server 2008 Q2780146 KB2780146 January 26, 2021
2778088 FIX: Memory leak if you enable the AUTO_UPDATE_STATISTICS_ASYNC statistics option in SQL Server 2008, in SQL Server 2012 or in SQL Server 2008 R2 Q2778088 KB2778088 January 26, 2021
2770891 FIX: "Non-yielding Scheduler" error message when you insert a record that contains large object (LOB) data into a snapshot database in SQL Server 2008 or in SQL Server 2008 R2 Q2770891 KB2770891 January 26, 2021
2770837 FIX: "Windows NT user or group 'Domain_name\User_name' not found" error message when you add a login to a case-sensitive SQL Server 2008 instance or SQL Server 2008 R2 instance Q2770837 KB2770837 January 26, 2021
2770635 FIX: Incorrect result when you run an MDX query against an SSAS 2008 R2 or SSAS 2012 database that has multiple data sources Q2770635 KB2770635 January 26, 2021
2756471 FIX: Incorrect result is returned when you query an indexed view by using the NOEXPAND hint in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2756471 KB2756471 January 26, 2021
2755079 FIX: Changes are not synchronized to subscribers after you change an article filter in a transactional replication publication in SQL Server 2008, in SQL Server 2012 or in SQL Server 2008 R2 Q2755079 KB2755079 January 26, 2021
2754301 FIX: Large queries that modify data run slower than expected when many locks accumulate in a SQL Server 2008 R2 or in SQL Server 2012 Q2754301 KB2754301 January 26, 2021
2746341 FIX: High CPU usage when you execute an UPDATE statement that includes a "WHERE CURRENT OF <cursor>" clause in SQL Server 2008 Q2746341 KB2746341 January 26, 2021
2737161 FIX: Cannot add an article to a publication that is in a database mirroring partnership in SQL Server 2008 or in SQL Server 2008 R2 Q2737161 KB2737161 January 26, 2021
2727322 FIX: Incorrect results are returned when you run a query that uses parallelism in the query execution plan in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2727322 KB2727322 January 26, 2021
2723474 FIX: Event ID 322 even though operations are successfully completed in SQL Server 2008 or in SQL Server 2008 R2 Q2723474 KB2723474 January 26, 2021
2720940 FIX: Corrupted codes are recorded in Application log or Security log when you audit an instance of SQL Server 2008 that is running on an IA-64 computer Q2720940 KB2720940 January 26, 2021
2715512 FIX: Error messages when you use dtexec to execute packages in SSIS 2008, in SSIS 2012 or in SSIS 2008 R2 Q2715512 KB2715512 January 26, 2021
2715312 FIX: Errors when you run a query that uses the FOR XML clause in the PATH mode in SQL Server 2008 R2 or in SQL Server 2012 Q2715312 KB2715312 January 26, 2021
2713151 FIX: Access violation when you use Database Engine Tuning Advisor to tune a table in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 if you enable the "Include filtered indexes" check box Q2713151 KB2713151 January 26, 2021
2711549 FIX: Error is logged when you start SQL Server 2008 or when a client sends a request to the program Q2711549 KB2711549 January 26, 2021
2706601 FIX: Series groups in a report are missing when you render the report in SQL Server 2008 Reporting Services or in later versions of Reporting Services Q2706601 KB2706601 January 26, 2021
2705236 FIX: An access violation occurs when you run a query that both uses the PIVOT operator and uses parallelism in the query execution plan in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2705236 KB2705236 January 26, 2021
2699013 FIX: SQL Server 2012, SQL Server 2008 R2 or SQL Server 2008 stops responding and a "Non-yielding Scheduler" error is logged Q2699013 KB2699013 January 26, 2021
2682488 FIX: Backup operation fails in a SQL Server database after you enable change tracking Q2682488 KB2682488 January 26, 2021
2680799 FIX: Error message when you perform a full population of a full-text index by using word breakers for Chinese language in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2680799 KB2680799 January 26, 2021
2675522 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2, in SQL Server 2008 or in SQL Server 2012 Q2675522 KB2675522 January 26, 2021
2673997 FIX: "The index data is damaged" error message when you run an MDX query against a dimension or partition in SSAS 2008, in SSAS 2008 R2 or in SSAS 2012 Q2673997 KB2673997 January 26, 2021
2673056 FIX: SQL Server Configuration Manager takes a long time to open if many SQL Server 2008 R2 or SQL Server 2012 instances are installed Q2673056 KB2673056 January 26, 2021
2671078 FIX: "Attempting to set a non-NULL-able column's value to NULL" error message when you use a MERGE statement in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2671078 KB2671078 January 26, 2021
2667742 FIX: "out of memory" error when you use ODBC with SQL Server 2012, SQL Server 2008 R2 or SQL Server 2008 Q2667742 KB2667742 January 26, 2021
2665649 FIX: "bufferLen >= colLen" assertion when you run a parallel query in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2665649 KB2665649 January 26, 2021
2660646 FIX: Incorrect result is returned when the STUnion() method is called between a geometry instance and a GEOMETRYCOLLECTION instance in a query in SQL Server 2008 Q2660646 KB2660646 January 26, 2021
2658474 FIX: Incorrect results when the SqlConnection.GetSchema method retrieves a table’s schema information in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2658474 KB2658474 January 26, 2021
2658234 FIX: Unnecessary updates to a subscriber after you reinitialize it if a new article is added to a publication in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2658234 KB2658234 January 26, 2021
2658214 FIX: Poor performance when you run a query that contains correlated AND predicates in SQL Server 2008 or in SQL Server 2008 R2 or in SQL Server 2012 Q2658214 KB2658214 January 26, 2021
2653857 FIX: You cannot connect to SQL Server by using JDBC Driver for SQL Server after you upgrade to JRE 6 update 29 or a later version Q2653857 KB2653857 January 26, 2021
2651629 FIX: Error message when you use DTA to tune one or more queries against a database that contains many objects in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2651629 KB2651629 January 26, 2021
2649913 FIX: Performance might decrease when you run a query that uses the sp_cursoropen stored procedure after you upgrade from SQL Server 2005 to SQL Server 2008 or to SQL Server 2008 R2 or to SQL Server 2012 Q2649913 KB2649913 January 26, 2021
2645648 FIX: Export procedure fails when you export a 64-bit SSRS 2008 R2 report, SSRS 2012 report or a SSRS 2008 report that contains multiple levels of a document map to the PDF format Q2645648 KB2645648 January 26, 2021
2644794 FIX: False assertion error when you try to convert the value from an XML column to an XML variable in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2644794 KB2644794 January 26, 2021
2643872 FIX: "HRESULT 0xE06D7363" error message when a client application uses the Microsoft.SqlServer.Types.dll component on a computer that has SQL Server 2008 SP2 installed Q2643872 KB2643872 January 26, 2021
2640110 FIX: An sp_execute_policy error if both SQL Server 2008 R2 and SQL Server 2008 are installed Q2640110 KB2640110 January 26, 2021
2638448 FIX: Access violation when a query is compiled or recompiled in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2638448 KB2638448 January 26, 2021
2635827 FIX: Access violation when you run a DBCC CHECKDB command against a database that contains a table that has a spatial index in SQL Server 2008 or in SQL Server 2008 R2 Q2635827 KB2635827 January 26, 2021
2635219 FIX: Non-ASCII data might be lost when you use the SQLBulkCopy class to transfer Non-ASCII data in SQL Server 2008 Q2635219 KB2635219 January 26, 2021
2629456 FIX: Access violation when you insert a record into a new empty partition in SQL Server 2008 or in SQL Server 2008 R2 Q2629456 KB2629456 January 26, 2021
2628126 FIX: "Fulltext index error during compression or decompression" error when you create a full-text index in SQL Server 2008 or in SQL Server 2008 R2 if the primary key is set to a BIGINT column Q2628126 KB2628126 January 26, 2021
2626246 FIX: Incorrect results when you run a query against a database that has a 90 collation in SQL Server 2008 or in SQL Server 2008 R2 Q2626246 KB2626246 January 26, 2021
2625768 FIX: A database page is copied into a database snapshot even though the page is not updated when you perform a read operation in SQL Server 2008 or in SQL Server 2008 R2 Q2625768 KB2625768 January 26, 2021
2622823 FIX: ghost_record_count values keep increasing in SQL Server 2008 R2 or in SQL Server 2008 Q2622823 KB2622823 January 26, 2021
2619077 FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry Q2619077 KB2619077 January 26, 2021
2618680 FIX: "Not registered correctly" error when you use a pull subscription and the Replication Interactive Conflict Resolver Q2618680 KB2618680 January 26, 2021
2618676 FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2 Q2618676 KB2618676 January 26, 2021
2616117 FIX: Incorrect mail profile is displayed in the Alert System page in SQL Server 2008 R2 Q2616117 KB2616117 January 26, 2021
2606301 FIX: High memory usage when you run Replication Snapshot Agent in SQL Server 2008 or in SQL Server 2008 R2 Q2606301 KB2606301 January 26, 2021
2606211 FIX: Error when a complex MDX query has the NONEMPTY clause in SSAS 2008 R2 or in SSAS 2012 if the WHERE clause has a named set Q2606211 KB2606211 January 26, 2021
2605756 FIX: Internal error when you run a MDX query that uses the Descendants function after you upgrade from SSAS 2005 to SSAS 2008, to SSAS 2008 R2 or to SSAS 2012 Q2605756 KB2605756 January 26, 2021
2603910 FIX: Backup fails in SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 if you enable change tracking on the database Q2603910 KB2603910 January 26, 2021
2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2598903 KB2598903 January 26, 2021
2591902 FIX: XML data loss when a merge replication encounters a foreign key violation error in SQL Server 2005, in SQL Server 2008, in SQL Server 2008 R2, or in SQL Server 2012 Q2591902 KB2591902 January 26, 2021
2591692 FIX: Non-convergence or data loss if a query times out during merge replication in SQL Server 2008 or in SQL Server 2008 R2 Q2591692 KB2591692 January 26, 2021
2591461 FIX: "Unexpected error from SE OLEDB interface" error when you run a full-text search query in SQL Server 2008 or in SQL Server 2008 R2 Q2591461 KB2591461 January 26, 2021
2590839 FIX: Low CPU spikes at a set interval even without user activity in SQL Server 2008 R2 or in SQL Server 2012 Q2590839 KB2590839 January 26, 2021
2589980 FIX: Incorrect results or constraint violation when you run a SELECT or DML statement that uses the row_number function and a parallel execution plan in SQL Server 2008 Q2589980 KB2589980 January 26, 2021
2588970 FIX: "Server: Msg 7359" error when you run a distributed query in SQL Server 2008 or in SQL Server 2008 R2 if a schema version is updated more than five times Q2588970 KB2588970 January 26, 2021
2588506 FIX: SQLGetDiagRec function does not return errors in SQL Server 2008 or in SQL Server 2008 R2 if more than 2100 query parameters are sent Q2588506 KB2588506 January 26, 2021
2588453 FIX: Access violation when DTA runs a query against a table in SQL Server 2008 if an index on a spatial data type column of the table exists Q2588453 KB2588453 January 26, 2021
2588050 FIX: Slipstream installation of a SQL Server 2008 or SQL Server 2008 R2 service pack fails when you add new features to the SQL instance if database engine is installed Q2588050 KB2588050 January 26, 2021
2587511 FIX: Error when a SQL Server performance condition alert is raised in SQL Server 2008 R2 Q2587511 KB2587511 January 26, 2021
2584903 FIX: Data Collector job takes a long time to clear data from an MDW database in SQL Server 2008 or SQL Server 2008 R2 Q2584903 KB2584903 January 26, 2021
2583994 FIX: SSIS Checkpoint restores an incorrect variable value for an Execute SQL Task item of a For Loop Container item in SSIS 2008 or in SSIS 2008 R2 if an SSIS package executes again after it fails or stops Q2583994 KB2583994 January 26, 2021
2576118 FIX: SSIS does not transfer a Flat File source data if the delimiter consists of two characters in SSIS 2008 R2 or SSIS 2008 Q2576118 KB2576118 January 26, 2021
2574973 FIX: Size of a data file that is committed by online page compression is larger than that is committed by offline page compression in SQL Server 2008 or in SQL Server 2008 R2 Q2574973 KB2574973 January 26, 2021
2574699 FIX: Database data files might be incorrectly marked as sparse in SQL Server 2008 R2 or in SQL Server 2008 even when the physical files are marked as not sparse in the file system Q2574699 KB2574699 January 26, 2021
2569923 FIX: Upload jobs of data collector quickly open and close a large number of TCP ports if the jobs upload data to a MDW database in SQL Server 2008 or in SQL Server 2008 R2 Q2569923 KB2569923 January 26, 2021
2567366 FIX: Slow performance when you restore a database in SQL Server 2008 R2, in SQL Server 2008 or in SQL Server 2012 if CDC is enabled Q2567366 KB2567366 January 26, 2021
2566163 FIX: Poor performance when table-valued functions use many table variables in SQL Server 2008 R2 or SQL Server 2008 Q2566163 KB2566163 January 26, 2021
2565683 FIX: You may receive incorrect results when you run a complex query that contains aggregates functions, join functions, and distinct functions in subqueries in a SQL Server 2008 or SQL Server 2008 R2 environment Q2565683 KB2565683 January 26, 2021
2562812 FIX: Error code 17065 when you trace a stored procedure that contains a TVP if the TVP contains a large amount of text or of image data in SQL Server 2008 or in SQL Server 2008 R2 Q2562812 KB2562812 January 26, 2021
2554905 FIX: "File error: Data may have been lost" error message when you use Excel 2010 to open an Excel report file that was exported from SSRS 2008, from SSRS 2008 R2 or from SSRS 2012 Q2554905 KB2554905 January 26, 2021
2550552 FIX: SQL Server command stops responding when it uses a nonbuffered access path to access a FILESTREAM file in SQL Server 2008 R2 or SQL Server 2008 Q2550552 KB2550552 January 26, 2021
2550375 FIX: Deadlock might occur in sys.dm_database_encryption_keys DMV in SQL Server 2008 R2 or in SQL Server 2012 when you run log shipping from many databases to one secondary server Q2550375 KB2550375 January 26, 2021
2548593 FIX: Database corruption if data compression enabled on a partitioned table in SQL Server 2008 Q2548593 KB2548593 January 26, 2021
2546715 FIX: Non-convergence when a custom stored procedure propagates data changes for a transactional replication in SQL Server 2008 or in SQL Server 2008 R2 Q2546715 KB2546715 January 26, 2021
2545989 FIX: "A time-out occurred while waiting for buffer latch" error when many transactions concurrently update a database in SQL Server 2008 R2 or in SQL Server 2008 if the database uses the snapshot isolation level Q2545989 KB2545989 January 26, 2021
2544983 FIX: "'Databaseproperty' is not a recognized built-in function name" error when you replicate a SQL Server 2008 or a SQL Server 2008 R2 transactional publication in SQL Server "Denali" Q2544983 KB2544983 January 26, 2021
2543687 FIX: Errors when a client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2 Q2543687 KB2543687 January 26, 2021
2543684 FIX: STRelate method incorrectly returns "1" when the two geometry instances are disjointed in SQL Server 2008 Q2543684 KB2543684 January 26, 2021
2542225 FIX: Assertion failure or other issues occur when you run a DML query against a table or view that has two indexes in SQL Server 2008 or in SQL Server 2008 R2 Q2542225 KB2542225 January 26, 2021
2539378 FIX: Replmerg.exe crashes when it enumerates changes to a statement in SQL Server if the stored procedure contains more than 4,000 characters Q2539378 KB2539378 January 26, 2021
2537973 FIX: Nested viewer incorrectly appears in Report Manager when you perform a search in an SSRS 2008 report in Internet Explorer 9.0 Q2537973 KB2537973 January 26, 2021
2537467 FIX: You cannot use SQL Server Management Objects (SMO) to transfer data from a table in SQL Server 2008 or in SQL Server 2008 R2 Q2537467 KB2537467 January 26, 2021
2536225 FIX: CLR stored procedure returns NULL after it is recompiled in SQL Server 2008 R2 or in SQL Server 2008 Q2536225 KB2536225 January 26, 2021
2535705 FIX: An access violation occurs when you restore a database and run the sp_replcounters stored procedure at the same time on a server that is running SQL Server 2008 or SQL Server 2008 R2 Q2535705 KB2535705 January 26, 2021
2532079 FIX: DML statements do not run on some columns in a table after you enable CDC on some other columns in SQL Server 2008 R2 Q2532079 KB2532079 January 26, 2021
2530921 FIX: Incorrect results when you run an INSERT SELECT UNION ALL statement in SQL Server 2008 or in SQL Server 2008 R2 Q2530921 KB2530921 January 26, 2021
2526959 FIX: Application performance issue when a query references temporary tables that are created in a session in SQL Server 2008 and in SQL Server 2008 R2 Q2526959 KB2526959 January 26, 2021
2526552 FIX: SQL Server Browser service periodically does not respond to incoming requests Q2526552 KB2526552 January 26, 2021
2525665 FIX: SQL Server 2008 BIDS stops responding when you stop debugging a SSIS 2008 or a SSIS 2008 R2 package Q2525665 KB2525665 January 26, 2021
2525165 FIX: Error message "ORA-01722: invalid number" when you replicate a table to an Oracle server subscriber in SQL Server 2008 or in SQL Server 2008 R2 if a varchar (max) column of the table contains a long value record Q2525165 KB2525165 January 26, 2021
2524743 FIX: Recovery takes longer than expected for a database in a SQL Server 2008 or in a SQL Server 2008 R2 environment Q2524743 KB2524743 January 26, 2021
2522893 FIX: A backup operation on a SQL Server 2008 or SQL Server 2008 R2 database fails if you enable change tracking on this database Q2522893 KB2522893 January 26, 2021
2520808 FIX: Non-yielding scheduler error when you run a query that uses a TVP in SQL Server 2008 or in SQL Server 2008 R2 if SQL Profiler or SQL Server Extended Events is used Q2520808 KB2520808 January 26, 2021
2519638 FIX: Error 6512 when you run the sp_addsubscription stored procedure if the "@sync_type" parameter is set to "replication support only" in SQL Server 2008 or in SQL Server 2008 R2 Q2519638 KB2519638 January 26, 2021
2519358 FIX: "The integer value is out of range" error when you pass a bigint value as the last_sync_version argument of the CHANGETABLE function in SQL Server 2008 or in SQL Server 2008 R2 Q2519358 KB2519358 January 26, 2021
2518306 FIX: MDX query returns incorrect results in SSAS 2008, in SSAS 2008 R2, or in SSAS 2012 if the data cache is not populated Q2518306 KB2518306 January 26, 2021
2515286 FIX: "There is no function '{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2515286 KB2515286 January 26, 2021
2511963 FIX: Query stops responding in SQL Server 2008 or in SQL Server 2008 R2 if the query alters or stops an Extended Events session Q2511963 KB2511963 January 26, 2021
2511151 FIX: Column of a Flat File source is not imported if the next column data is one byte longer than the output column width in SSIS 2005, SSIS 2008 or in SSIS 2008 R2 Q2511151 KB2511151 January 26, 2021
2506795 FIX: "Insufficient data for an Image" error when you open a .pdf file that is exported from a SQL Server 2008 Reporting Services or SQL Server 2008 R2 Reporting Services environment Q2506795 KB2506795 January 26, 2021
2506235 FIX: An access violation may occur when a database is enabled for Transparent Database Encryption in SQL Server 2008 or in SQL Server 2008 R2 Q2506235 KB2506235 January 26, 2021
2504090 FIX: Access violation or incorrect result when you insert data into or update a new partition of a partitioned table in SQL Server 2008 R2, SQL Server 2012 or SQL Server 2008 Q2504090 KB2504090 January 26, 2021
2499023 FIX: Incorrect results when a complex update query uses the JOIN operator in an execution plan in SQL Server 2008 or in SQL Server 2008 R2 Q2499023 KB2499023 January 26, 2021
2498818 FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Q2498818 KB2498818 January 26, 2021
2498796 FIX: An access violation may occur when you update the statistics of a table after you enable and then disable conflict detection on a table in in SQL Server 2008 or in SQL Server 2008 R2 Q2498796 KB2498796 January 26, 2021
2497575 FIX: "Error: 18210, Severity: 16, State: 1" error when an application tries to use VDI to back up some data in a SQL Server 2008 or SQL Server 2008 R2 instance Q2497575 KB2497575 January 26, 2021
2496375 FIX: "Could not open global shared memory to communicate with performance DLL" warning when you run an SSIS 2008 or SSIS 2008 R2 package on a computer that is running Windows XP Q2496375 KB2496375 January 26, 2021
2491510 FIX:A query that has a CONTAINS predicate in a WHERE clause takes a long time to compile in SQL Server 2008 or SQL Server 2008 R2 Q2491510 KB2491510 January 26, 2021
2491210 FIX: Maintenance plan does not back up a database that is set to AUTO_CLOSE, RESTORING, or STANDBY in SQL Server 2008 or in SQL Server 2008 R2 Q2491210 KB2491210 January 26, 2021
2490920 FIX: "Msg 2601, Level 14, State 1, Line 1 Cannot insert duplicate key row" error when you run the ALTER PARTITION FUNCTION statement to split or merge a partition range in SQL Server 2005 or in SQL Server 2008 Q2490920 KB2490920 January 26, 2021
2489667 FIX: SQL Server Agent job runs incorrectly if it is scheduled to run every hour on the last day of every week or month in SQL Server 2005 or in SQL Server 2008 or in SQL Server 2008 R2 Q2489667 KB2489667 January 26, 2021
2484392 FIX: "xact_seqno" column in the "MSrepl_errors" table does not record a skipped row in SQL Server 2008 or in SQL Server 2008 R2 if you use the "-SkipErrors" parameter in the Distribution Agent Q2484392 KB2484392 January 26, 2021
2482977 FIX: 10061 Winsock error code occurs when an application uses the extended OLE DB initialization properties for the SQL Server Native Client 10.0 OLE DB provider in the connection string Q2482977 KB2482977 January 26, 2021
2481274 FIX: A query that uses the DATEDIFF function may run slowly in SQL Server 2005 or in SQL Server 2008 or in SQL Server 2008 R2 Q2481274 KB2481274 January 26, 2021
2478514 FIX: "The merge process could not access row data" error occurs when the Merge Agent stops, and rows are set to 4 in the genstatus column in the msmerge_genhistory system table Q2478514 KB2478514 January 26, 2021
2476322 FIX: A common table expression-based query that uses the CHANGETABLE function runs very slowly in SQL Server 2008 Service Pack 1 or SQL Server 2008 R2 Q2476322 KB2476322 January 26, 2021
2465092 FIX: "SQLSTATE: HY000" error occurs when you use Microsoft OLE DB Provider for DB2 v3 to load data in SSIS by using a FastLoad option Q2465092 KB2465092 January 26, 2021
2463682 FIX: Database with transparent data encryption enabled is marked as "suspect" if the server certificate is dropped in SQL Server 2008 or in SQL Server 2008 R2 Q2463682 KB2463682 January 26, 2021
2459742 FIX: The columns do not replicate correctly when you use Web synchronization for a merge replication in SQL Server 2008 if a column contains a NULL value Q2459742 KB2459742 January 26, 2021
2459027 FIX: "Index was outside the bounds of the array" SMO error message when you connect to a SQL Server code-named 'Denali' CTP1 Database Engine instance in SSMS 2008 R2 and in SSMS 2008 Q2459027 KB2459027 January 26, 2021
2455614 FIX: BIDS for SQL Server 2008 or SQL Server 2008 R2 responds very slowly when you design an MDX query that has many query parameters Q2455614 KB2455614 January 26, 2021
2451540 FIX: Poor performance may occur when you execute a query that contains multiple self-join operations on the same column in SQL Server 2005, in SQL Server 2008 and in SQL Server 2008 R2 Q2451540 KB2451540 January 26, 2021
2448991 FIX: The variables of an SSIS 2008, SSIS 2008 R2 or SSIS 2005 package are evaluated incorrectly when you run the package in parallel Q2448991 KB2448991 January 26, 2021
2448971 FIX: The locks of a table are not escalated when you insert many rows into a table in SQL Server 2008 or in SQL Server 2008 R2 Q2448971 KB2448971 January 26, 2021
2446860 FIX: The sys.syscommittab system table is not cleaned up after the retention period for change tracking in SQL Server 2008 Q2446860 KB2446860 January 26, 2021
2445812 FIX: A column that uses the DATETIME data type does not replicate to an Oracle subscriber by using a transactional replication in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2445812 KB2445812 January 26, 2021
2444085 FIX: "Transaction is already aborted (WinMgmt)" error when you run DTC transactions from BizTalk Server 2009 to SQL Server 2008 or SQL Server 2008 R2 if event notifications are enabled Q2444085 KB2444085 January 26, 2021
2435844 FIX: A SQL Server Agent job incorrectly runs after the specified end date in SQL Server 2008 and in SQL Server 2008 R2 Q2435844 KB2435844 January 26, 2021
2435404 FIX: Computer stops responding when you create a database that contains a FILESTREAM filegroup in SQL Server 2008 or in SQL Server 2008 R2 if a third-party mini-filter driver is installed Q2435404 KB2435404 January 26, 2021
2433265 FIX: You may receive an incorrect result when you run a query that uses the ROW_NUMBER function together with a left outer join in SQL Server 2008 and SQL Server 2008 R2 Q2433265 KB2433265 January 26, 2021
2432235 FIX: High memory consumption may occur when you rebuild a single partition of the heap table in SQL Server 2008 or SQL Server 2008 R2 Q2432235 KB2432235 January 26, 2021
2428916 FIX: A performance condition alert is incorrectly raised in SQL Server 2008 or SQL Server 2008 R2 if a case-sensitive collation is configured Q2428916 KB2428916 January 26, 2021
2421014 FIX: "A severe error occurred on the current command" error message when you use the Freetexttable or the Containstable function on an indexed view in a CTE query in SQL Server 2008 or in SQL Server 2008 R2 Q2421014 KB2421014 January 26, 2021
2413430 FIX: "Cannot locate version record and page is not allocated" error message occurs when you rebuild an index by using the ONLINE option in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2413430 KB2413430 January 26, 2021
2407172 FIX: An exception occurs before the error output for invalid data of an "XML Source" task is redirected in SSIS 2005, SSIS 2008 or SSIS 2008R2 Q2407172 KB2407172 January 26, 2021
2406666 FIX: "[Teradata Database] [3737]" error when you click "Count" in the Aggregation Design Wizard in SSAS 2008, in SSAS 2012 or in SSAS 2008 R2 Q2406666 KB2406666 January 26, 2021
2404865 FIX: High CPU usage when you run a SQL Server Agent job in SQL Server 2008 or SQL Server 2008 R2 if a column of a dynamic SELECT statement has a value that is many characters long Q2404865 KB2404865 January 26, 2021
2403218 FIX: Database mirroring session is suspended in SQL Server 2005 and in SQL Server 2008 and in SQL Server 2008 R2 if the High-performance (asynchronous) mode is used Q2403218 KB2403218 January 26, 2021
2397020 FIX: "Access is denied. [0x80070005]" error message occurs in SSCM when you try to change the password of an account of SQL Server 2008 or SQL Server 2008 R2 in Windows Vista or in a later version of Windows Q2397020 KB2397020 January 26, 2021
2387686 FIX: "A MOF syntax error occurred" error message occurs when you try to install SQL Server 2008 or SQL Server 2008 R2 Q2387686 KB2387686 January 26, 2021
2384766 FIX: The ANSI_NULLS property of an indexed view is changed to FALSE after the indexed view is replicated to the subscription database in SQL Server 2008 or in SQL Server 2008 R2 Q2384766 KB2384766 January 26, 2021
2380435 FIX: The query plan for a stored procedure is not cached if the stored procedure uses a BLOB variable and the variable is used in a string function in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q2380435 KB2380435 January 26, 2021
2380361 FIX: Error message when you run the "sp_createstats" stored procedure in SQL Server 2008 or in SQL Server 2008 R2 if the table contains a nondeterministic computed column Q2380361 KB2380361 January 26, 2021
2379466 FIX: "0x84B10001" error code, SQL Server 2008 or SQL Server 2008 R2 Setup failure, and an unhandled exception occur when you run SQL Server 2008 or SQL Server 2008 R2 Setup Q2379466 KB2379466 January 26, 2021
2357947 FIX: Incorrect order of the characters and numbers when you use OLE DB Provider for DB2 version 3.0 if the column contains some Hebrew characters Q2357947 KB2357947 January 26, 2021
2352413 FIX: Query failure and an "Invalid column name" error message occur when you run a linked server query to another instance of SQL Server 2008 or SQL Server 2008 R2 Q2352413 KB2352413 January 26, 2021
2344600 FIX: "Non-yielding Scheduler" error may occur when you use the CONTAINSTABLE function together with many OR and AND predicates in SQL Server 2008 or in SQL Server 2008 R2 Q2344600 KB2344600 January 26, 2021
2316135 FIX: "An unexpected exception occurred" internal error and heap corruption occurs when you run a MDX query that is generated by third-party software in SSAS 2008 Q2316135 KB2316135 January 26, 2021
2306162 FIX: Poor performance and some occasional non-yielding scheduler errors occur when you create a complex view that references a large amount of nested views or tables in SQL Server 2008 or in SQL Server 2008 R2 Q2306162 KB2306162 January 26, 2021
2300689 FIX: You cannot restore a backup of a database on another instance of SQL Server if you disable transparent data encryption before you create the backup in SQL Server 2008 or in SQL Server 2008 R2 Q2300689 KB2300689 January 26, 2021
2297903 FIX: Event ID 322 is logged when a server audit is output in SQL Server 2008 or SQL Server 2008 R2 Q2297903 KB2297903 January 26, 2021
2297709 FIX: An error message may occur when you run a "BULK INSERT" query on a database that uses the "BULK_LOGGED" or "SIMPLE" recovery model in SQL Server Q2297709 KB2297709 January 26, 2021
2297308 FIX: "A previous filestream configuration attempt was incomplete" error and an access violation occur when you perform post-setup configuration of the FILESTREAM feature on a SQL Server 2008 or SQL Server 2008 R2 failover cluster Q2297308 KB2297308 January 26, 2021
2295878 FIX: LOB pages that are allocated in a failed INSERT statement may not be reclaimed after you apply SQL Server 2005 SP3, SQL Server 2005 SP4, SQL Server 2008 SP1 or SQL Server 2008 R2 Q2295878 KB2295878 January 26, 2021
2295869 FIX: An unresolved deadlock occurs when a database is recovered in SQL Server 2005, SQL Server 2008, or in SQL Server 2008 R2 Q2295869 KB2295869 January 26, 2021
2295460 Fix: Replication error message when you register a custom resolver to a merge replication in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 if a BIGINT column contains a NULL value Q2295460 KB2295460 January 26, 2021
2287990 FIX: The "Derived Column" transformation may produce incorrect results when you run a package in Microsoft SQL Server 2008 or SQL Server 2008 R2 Integration Services Q2287990 KB2287990 January 26, 2021
2285711 FIX: A fix is available that improves the manageability of SSMS 2008 R2 to support Spatial Types for SQL Azure Q2285711 KB2285711 January 26, 2021
2283072 FIX: A hotfix is available that enables SQL Server 2008 Reporting Services and SQL Server 2008 R2 Reporting Services to use a 2048-bit RSA key to encrypt a Reporting Services key for FIPS compliancy Q2283072 KB2283072 January 26, 2021
2282743 FIX: The special characters are displayed incorrectly in a "TextBox" control of a PDF file when you render a report in SSRS 2008 Q2282743 KB2282743 January 26, 2021
2280390 FIX: Error message when you query an XML data type column in an SQL table on a server that is running SQL Server 2008 or SQL Server 2008 R2: "Index was outside the bounds of the array" Q2280390 KB2280390 January 26, 2021
2278042 FIX: A derived column transformation may generate incorrect results in SSIS 2008 or in SSIS 2008 R2 when a column is derived both in read-only usage and in read/write usage Q2278042 KB2278042 January 26, 2021
2277207 FIX: The value of the "Axis" label appears in each column and the "Gridline Interval" value is not honored after a RDL file is upgraded from SSRS 2005 to SSRS 2008 Q2277207 KB2277207 January 26, 2021
2277078 FIX: The TokenAndPermUserStore cache store size continues to grow when you enable a SQL Server audit in SQL Server 2008 R2 and in SQL Server 2008 Q2277078 KB2277078 January 26, 2021
2276717 FIX: Error code 1456 when you add a witness to a new database mirroring session that has the same database name as an existing database mirroring session in Microsoft SQL Server 2008 and in Microsoft SQL Server 2008 R2 Q2276717 KB2276717 January 26, 2021
2276330 FIX: The "CHANGETABLE" function is slow in SQL Server 2008 and in SQL Server 2008 R2 Q2276330 KB2276330 January 26, 2021
2268122 FIX: "User 'guest' does not have permission to run DBCC checkdb for database 'mssqlsystemresource'" error message when you run the DBCC CHECKDB('master') command on a computer that is running SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2268122 KB2268122 January 26, 2021
2261403 FIX: The "SQL Server:SSIS Pipeline 10.0" performance object does not appear in the "Performance object" list while another user accesses some SSIS pipeline counters in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005 Q2261403 KB2261403 January 26, 2021
2260502 FIX: Query performance decreases after you upgrade to SQL Server 2008 or SQL Server 2008 R2 from SQL Server 2000 if the query uses a user-defined scalar function Q2260502 KB2260502 January 26, 2021
2256829 FIX: A certain number of the last XML columns may not be replicated correctly if you use web synchronization for merge replication in SQL Server 2008 or SQL Server 2008 R2 Q2256829 KB2256829 January 26, 2021
2214666 FIX: An SSIS package that uses the Unpivot transformation may produce inconsistent results in SQL Server 2008 or SQL Server 2008 R2 Q2214666 KB2214666 January 26, 2021
2159286 FIX: The Remote Registry service crashes when an application tries to retrieve performance counter data from an instance of SQL Server on another computer Q2159286 KB2159286 January 26, 2021
2152148 FIX: "Internal error: An unexpected exception occurred" error message when you run a Multidimensional Expressions (MDX) query by using time intelligence in Microsoft SQL Server Analysis Services 2008 Q2152148 KB2152148 January 26, 2021
2142496 FIX: A SQL Server 2008 R2 or SQL Server 2008 Integration Services package does not run in SQL Server Business Intelligence Development Studio when you use a shared SQL configuration table Q2142496 KB2142496 January 26, 2021
2028830 FIX: Shared components are installed in the wrong location when you implement a SQL Server 2008 or SQL Server 2012 Failover Cluster installation Q2028830 KB2028830 January 26, 2021
2028727 FIX: Column group values are displayed in only the last child row group of the adjacent row groups in SSRS 2008 Q2028727 KB2028727 January 26, 2021
983286 FIX: "A connection cannot be made" error message in SSAS 2008 or SSAS 2008 R2 when you try to connect to a database Q983286 KB983286 January 26, 2021
982924 FIX: "System.Exception: Win32.ExtTextOut failed; Win32 error:997" error message when the EMF printing renderer is under stress or when you try to print multiple reports at the same time in SSRS 2008 Q982924 KB982924 January 26, 2021
982854 FIX: Error "There is insufficient system memory in resource pool 'internal' to run this query" in Microsoft SQL Server Q982854 KB982854 January 26, 2021
982441 FIX: You receive error 666 when you rebuild an index online on a partition scheme in SQL Server 2008 or SQL Server 2008 R2 Q982441 KB982441 January 26, 2021
982376 FIX: A non-yielding scheduler error or an error 8623 occurs when you run a query that contains a large IN clause in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q982376 KB982376 January 26, 2021
981611 FIX: An access violation occurs when you use the COUNT_BIG function and the OVER clause in a query in SQL Server 2008 or SQL Server 2008 R2 Q981611 KB981611 January 26, 2021
981108 FIX: Error message when SQL Server 2008 Reporting Services or the SQL Server 2008 database engine is running: "Fatal Execution Engine Error (000006427F44AE16)" or "A fatal error occurred in the .NET Framework common language runtime" Q981108 KB981108 January 26, 2021
980849 FIX: You experience high latency for peer-to-peer distribution agents in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 Q980849 KB980849 January 26, 2021
980832 FIX: "A system assertion check has failed" error message when you run a Transaction-SQL query in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q980832 KB980832 January 26, 2021
980142 FIX: "Provider Load Failure" error message or the Wmiprvse.exe process stops responding when you use a SQL Server WMI provider to obtain information about SQL Server 2012, SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 services Q980142 KB980142 January 26, 2021
979785 FIX: Error message when you use the Script Wizard to generate scripts for stored procedures in SQL Server 2008 or SQL Server 2008 R2 Q979785 KB979785 January 26, 2021
979779 FIX: Several problems occur when you use a linked server that was created by the SQL Native Client provider in SQL Server 2008 Q979779 KB979779 January 26, 2021
979212 FIX: A DateTime value is replaced by a NULL value when a conflict is resolved by using a custom resolver in Microsoft SQL Server 2005, Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2 merge replication Q979212 KB979212 January 26, 2021
978629 FIX: Error message when you use the system_health Extended Event session to capture a deadlock graph in SQL Server 2008: "Msg 9436: XML parsing: line 54, character 12, end tag does not match start tag" Q978629 KB978629 January 26, 2021
975915 FIX: An arithmetic overflow error occurs intermittently during the "Collect a snapshot of sys.dm_exec_query_stats" phase after you enabled data collector in SQL Server 2008 Q975915 KB975915 January 26, 2021
975752 FIX: "ConnConnectAndSetCryptoForXpstar failed (0)"error message occurs when you try to start the SQL Server Agent service from a Remote Desktop session in SQL Server 2008 or in SQL Server 2008 R2 Q975752 KB975752 January 26, 2021
975374 FIX: The check phase of the WMI service fails when you set up a SQL Server 2008 cluster Q975374 KB975374 January 26, 2021
974660 FIX: You receive out-of-memory error messages when you use merge replication with Web synchronization in SQL Server 2005 or in SQL Server 2008 Q974660 KB974660 January 26, 2021
974076 FIX: Error message when you use the DTExec.exe or DTExecUi.exe utility to run a SQL Server 2008 Integration Services package by specifying a configuration file: “The package path referenced an object that cannot be found” Q974076 KB974076 January 26, 2021
973524 FIX: The execution of the xp_readerrorlog command in SQL Server 2005 and in SQL Server 2008 stops responding and the usage of the CPU that is running the command increases to 100 percent Q973524 KB973524 January 26, 2021
971622 FIX: The memory usage of a SQL Server service increases quickly when you run a query that uses a linked server in SQL Server 2005 or in SQL Server 2008 Q971622 KB971622 January 26, 2021
971051 FIX: Error message when you run a SQL Server 2008-based application that calls the SQLBindParameter function: "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect" Q971051 KB971051 January 26, 2021
969845 FIX: Error message when you run a SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Integration Services package (SSIS) after you install the .NET Framework 2.0 SP2 or the .NET Framework 3.5 SP1: "ADO NET Source [1424]" Q969845 KB969845 January 26, 2021
969793 FIX: Error message when you click the Columns tab in OLE DB Source Editor in SQL Server 2008 Integration Services: "Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR" Q969793 KB969793 January 26, 2021
968834 FIX: Error message when you send an e-mail by using Database Mail in SQL Server 2005 or in SQL Server 2008: "The operation has timed out" Q968834 KB968834 January 26, 2021
968830 FIX: An incorrect version is displayed on the Instance Selection page when you use SQL Server 2008 Setup to upgrade an instance of SQL Server 2008 Q968830 KB968830 January 26, 2021
968215 FIX: Error message when you try to bulk insert data into a table that contains a DATE type column that uses a US date format in SQL Server 2008 or in SQL Server 2008 R2: "Bulk load data conversion error" Q968215 KB968215 January 26, 2021
967749 FIX: Error message when you view a SQL Server 2008 Reporting Services report that contains more than one subreport: "Error: Subreport could not be shown" Q967749 KB967749 January 26, 2021
967552 FIX: SQL Server 2008 Database Auditing shows query criteria as a parameterized value instead of the actual record Q967552 KB967552 January 26, 2021
963659 FIX: You receive error messages when you perform a population for a large full-text index in SQL Server 2008 or in SQL Server 2008 R2 Q963659 KB963659 January 26, 2021
961126 FIX: Error message when you run a maintenance plan in SQL Server 2008: "The SQL Server Execute Package Utility requires Integration Services to be installed" Q961126 KB961126 January 26, 2021
960770 FIX: You receive error 605 and error 824 when you run a query that inserts data into a temporary table in SQL Server Q960770 KB960770 January 26, 2021
958778 FIX: The default instance name is set incorrectly to SQLEXPRESS when you install SQL Server 2008 Express Q958778 KB958778 January 26, 2021
958745 FIX: Error message when you try to run or preview a very large report in Microsoft SQL Server 2008 Reporting Services: "Exception of type System.OutOfMemoryException was thrown" Q958745 KB958745 January 26, 2021
958611 FIX: You may receive incorrect results when you run a query that references three or more tables in the FROM clause in SQL Server 2008 Q958611 KB958611 January 26, 2021
958006 FIX: The size of the error log file for the SQL Server 2008 error log file grows very quickly when query notifications are created and destroyed in a high ratio Q958006 KB958006 January 26, 2021
957823 FIX: The clustered index table may take longer than you expect to be rebuilt when you use the ALTER INDEX REBUILD statement in SQL Server Q957823 KB957823 January 26, 2021
957459 FIX: Error message when you try to add a second node to a SQL Server 2008 failover cluster: "The current SKU is invalid" Q957459 KB957459 January 26, 2021
957453 FIX: When you install SQL Server 2008, the installation fails, and the "Attributes do not match" error message is logged in the Summary.txt file Q957453 KB957453 January 26, 2021
956718 FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key and there is a single row as the update source in SQL Server 2008 Q956718 KB956718 January 26, 2021
954950 FIX: Error message when you run a distributed query in SQL Server 2005 or SQL Server 2008: "OLE DB provider 'SQLNCLI' for linked server '<Linked Server>' returned message 'No transaction is active'" Q954950 KB954950 January 26, 2021
942712 FIX: The W3WP.exe process of Internet Information Services stops unexpectedly when you configure a merge replication that uses Web synchronization in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 Q942712 KB942712 January 26, 2021
930283 FIX: You receive error 1456 when you add a witness to a database mirroring session and the database name is the same as an existing database mirroring session in SQL Server 2005 or SQL Server 2008 Q930283 KB930283 January 26, 2021
926292 FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order Q926292 KB926292 January 26, 2021
922578 FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Errorlog file when you use SQL Server Profile in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q922578 KB922578 January 26, 2021
3137281 FIX: Communication that uses an MD5 hash algorithm fails when you use TLS 1.2 in SQL Server Q3137281 KB3137281 January 25, 2021
2830722 FIX: Access violation when you use a SQL profiler to trace an RPC event class in SQL Server 2008 or SQL Server 2008 R2 Q2830722 KB2830722 January 25, 2021
972767 FIX: The SQL Server database engine and SQL Server Reporting Services may consume more power on Windows client computers than expected Q972767 KB972767 January 25, 2021
2901479 FIX: You experience query failure when you run MDX queries in SSAS 2008 Q2901479 KB2901479 January 20, 2021
2591753 FIX: An update is available to add SPN information for service accounts to the Reporting Services log file Q2591753 KB2591753 October 20, 2020
978190 FIX: You receive error message 8630 when you run a query on a SQL Server 2008 server that is under memory pressure Q978190 KB978190 September 29, 2020
976316 FIX: You receive error message 8672 when you run a MERGE statement in SQL Server 2008 Q976316 KB976316 September 29, 2020
976231 FIX: Error message when you install SQL Server 2008 Express edition on a computer that is running the Chinese Traditional version of Windows Vista for Hongkong: “Performance counter registry hive consistency” Q976231 KB976231 September 29, 2020
975681 FIX: The database mirroring session is suspended when you add more than one log transaction file to a folder on the principle server that does not exist on the mirror server in SQL Server 2005 or in SQL Server 2008 Q975681 KB975681 September 29, 2020
975090 FIX: Deadlocks may occur when multiple concurrent query notification subscriptions are fired on same objects in SQL Server 2005 or in SQL Server 2008 Q975090 KB975090 September 29, 2020
975055 FIX: Error message when you install SQL Server 2008 on a computer that is running Windows 7: "Invoke or BeginInvoke cannot be called on a control until the window handle has been created." Q975055 KB975055 September 29, 2020
975027 FIX: You take a long time to stop the SQL Server service and you cannot restart the SQL Server service in a Microsoft SQL Server 2008 cluster environment when the server is under stress Q975027 KB975027 September 29, 2020
972498 FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008 Q972498 KB972498 September 29, 2020
971402 FIX: Error message when you send an e-mail by using a private Database Mail profile in SQL Server 2005 or in SQL Server 2008: "profile name is not valid" Q971402 KB971402 September 29, 2020
970399 FIX: The MAXDOP option for a running query or the max degree of parallelism option for the sp_configure stored procedure does not work in SQL Server 2008 Q970399 KB970399 September 29, 2020
969672 FIX: SQL Server 2008 Setup fails if you installed the security update package 954459 for MSXML Core Services 6.0 Q969672 KB969672 September 29, 2020
969611 FIX: Error message when you run a job whose owner is a Windows user account after SQL Server 2005 Agent or SQL Server 2008 Agent is restarted: "The job failed. The owner () of job <Job Name> does not have server access" Q969611 KB969611 September 29, 2020
968722 FIX: The CPU usage of the resource monitor is very high when the virtual memory is running low in SQL Server 2008 Q968722 KB968722 September 29, 2020
967205 FIX: A time-out occurs when you use SQL Server Management Studio to try to restore a large database from a backup on a tape in SQL Server 2008 Q967205 KB967205 September 29, 2020
966306 FIX: You cannot disable the CDC feature if you drop the cdc.change_tables CDC system table in SQL Server 2008 Q966306 KB966306 September 29, 2020
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 September 29, 2020
960573 FIX: Error message when you try to create a WMI event alert by using the sp_add_alert stored procedure in SQL Server 2008: "The @wmi_query could not be executed in the @wmi_namespace provided" Q960573 KB960573 September 29, 2020
959794 FIX: Error message when you use a SQL Server 2008 Integration Services package to query a table in an Oracle database: "SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR" Q959794 KB959794 September 29, 2020
958760 FIX: You may experience issues when you try to expand the Databases node in SQL Server Management Studio, or the sp_spaceused stored procedure takes a long time to run in SQL Server 2008 Q958760 KB958760 September 29, 2020
4539036 Frequently asked questions about ESU for Windows Server and SQL Server 2008 and 2008 R2 Q4539036 KB4539036 February 4, 2020
941105 FIX: Error messages after SQL Server has been running for some time on Windows Server 2003 or on Windows 2000: "Failed to load FileName.dll" and "Attempts to load any type of dll might fail within the SQL Server process" Q941105 KB941105 November 20, 2019
2399715 FIX: An "UPDATE CUBE" statement returns an incorrect error message when you try to update a calculated member in SSAS 2008 Q2399715 KB2399715 September 26, 2018
2322209 FIX: Incorrect results if you use parentheses around SELECT in a statement that has a common table expression in SQL Server 2008 Q2322209 KB2322209 September 21, 2018
2270925 FIX: PowerPivot workbooks are always loaded to the PowerPivot server that is last added to the SharePoint farm despite the use of server health based allocation or round-robin allocation Q2270925 KB2270925 September 20, 2018
981037 FIX: "Attempting to set a non-NULL-able column's value to NULL" error message when you run a query that uses the ISNULL() function to select values of a nullable column in SQL Server 2008 Q981037 KB981037 September 20, 2018
2509659 FIX: The dbo schema is preappended when you use a custom stored procedure in the sp_addarticle stored procedure Q2509659 KB2509659 September 19, 2018
962008 FIX: Error message when you use log shipping in SQL Server 2008: "During startup of warm standby database '<Database Name>' (database ID <N>), its standby file ('<File Name>') was inaccessible to the RESTORE statement" Q962008 KB962008 September 19, 2018
955814 FIX: Error message when you install SQL Server 2008 Express edition on a domain controller that is running Windows Server 2003 SP2 or Windows Small Business Server 2003 SP1: "Exception has been thrown by the target of invocation" Q955814 KB955814 July 11, 2018
974205 FIX: Error message in the Errorlog file of SQL Server 2005 or of SQL Server 2008 after the SQL Server service stops responding: "Timeout occurred while waiting for latch" Q974205 KB974205 April 21, 2018
973588 FIX: You receive various error messages when you open a SQL Server Reporting Services report whose data source uses the HTTP protocol to connect to SQL Server 2008 Analysis Services Q973588 KB973588 April 21, 2018
973303 FIX: Error message when you run the sp_add_alert stored procedure in SQL Server 2008 on a computer that is running Windows Server 2008 or Windows Vista: "SQLServerAgent Error: WMI error: 0x80041003" Q973303 KB973303 April 21, 2018
969775 FIX: Distribution Agent fails when you try to apply a snapshot for a newly added view in a publication in SQL Server 2005 or in SQL Server 2008 Q969775 KB969775 April 21, 2018
961695 FIX: Error message when you try to convert a variable of the numeric(2,0) data type to a tinyint data type in SQL Server 2008: "Arithmetic overflow error converting expression to data type tinyint" Q961695 KB961695 April 21, 2018
955828 FIX: Error message when you try to enable FILESTREAM settings in SQL Server 2008 or in SQL Server 2008 R2: “There was an unknown error applying the FILESTREAM settings” Q955828 KB955828 April 21, 2018
978430 FIX: The Ghost Cleanup task uses 100% of the CPU on an idle system in SQL Server 2008 or in SQL Server 2005 Q978430 KB978430 April 20, 2018
973301 FIX: Error message when you install SQL Server 2008 or SQL Server 2008 Service Pack 1 on a Windows XP-based computer that has SQL Server 2000 installed: "Object reference not set to an instance of an object." Q973301 KB973301 April 20, 2018
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 18, 2017
971132 FIX: The HTML format of a SQL Server 2008 Reporting Services report is not compliant with section 1194.22 standards in the Section 508 standards Q971132 KB971132 December 10, 2015
972759 FIX: Installing SQL Server 2008 Service Pack 1 may reset the "max_worker_threads" column value for a SQL Server Agent subsystem Q972759 KB972759 August 17, 2015
2793580 FIX: An update enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server Q2793580 KB2793580 January 19, 2015
911678 FIX: User Transaction is Aborted When fn_trace_gettable Reads Corrupt Trace File Q911678 KB911678 January 17, 2015
975272 FIX: An access violation occurs when you run a MDX query that involves a calculated member that uses the SUM({set of measures}) function where the set contains measures from different measure groups in SQL Server 2008 Q975272 KB975272 January 16, 2015
974371 FIX: The performance decreases when you open the Report Builder (RB) ClickOnce application after you install SQL Server 2008 Service Pack 1 Q974371 KB974371 January 16, 2015
974289 FIX: Error message when you analyze a trace file in Database Engine Tuning Advisor in SQL Server 2008: “Error converting data type varchar to datetime” Q974289 KB974289 January 16, 2015
973696 FIX: Change tracking cleanup does not clean up the sys.syscommittab system table in SQL Server 2008 Q973696 KB973696 January 16, 2015
973223 FIX: You cannot synchronize data for a peer-to-peer replication after you perform a dummy update operation in SQL Server 2008 Q973223 KB973223 January 16, 2015
973200 FIX: No results are returned when you run an MDX query that references a calculated member in SQL Server 2008 Q973200 KB973200 January 16, 2015
972261 FIX: Error message when you run a MERGE statement on a table that has a unique clustered index and a nonclustered index in SQL Server 2008: "Cannot insert duplicate key row in object '<TableName>' with unique index '<IndexName>'" Q972261 KB972261 January 16, 2015
972200 FIX: Error message when you try to disable Resource Governor by using the UI in SQL Server 2008 Management Studio after you drop a Resource Governor workload group: "Alter failed for ResourceGovernor 'Microsoft.SqlServer.Management.Smo.ObjectKeyBa... Q972200 KB972200 January 16, 2015
971068 FIX: Error message when you create a SharePoint subscription on a SQL Server 2008 Reporting Services report that uses cascading parameters: "This report requires a default or user-defined value for the report parameter '<Parameter>'" Q971068 KB971068 January 16, 2015
970287 FIX: A performance issue occurs when you run a full-text query that contains the "AND NOT" clause in SQL Server 2008 Q970287 KB970287 January 16, 2015
969997 FIX: You receive an incorrect result when you query data from a linked server that is created by using an index OLE DB provider in SQL Server 2005 or in SQL Server 2008 Q969997 KB969997 January 16, 2015
968741 FIX: You receive asserts after you delete a row that contains BLOB data from a SQL Server 2008 database Q968741 KB968741 January 16, 2015
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 January 16, 2015
961283 FIX: An access violation may occur when you run a query that uses a parallel execution plan in SQL Server 2008 Q961283 KB961283 January 16, 2015
961272 FIX: A maintenance plan that contains a Rebuild Index task takes much longer than you expect to run in SQL Server 2008 Q961272 KB961272 January 16, 2015
961271 FIX: In a SQL Server 2008 Reporting Services report that contains several levels, some items disappear when you collapse another item Q961271 KB961271 January 16, 2015
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 January 16, 2015
961094 FIX: Error message when you try to connect to a cube by using a user account that belongs to multiple database roles in SQL Server 2008 Analysis Services: "Two sets specified in the function have different dimensionality" Q961094 KB961094 January 16, 2015
960864 FIX: Error message when you view a mining model in Mining Model Viewer in SQL Server 2008 Analysis Services: "Exception has been thrown by the target of an invocation.Item has already been added" Q960864 KB960864 January 16, 2015
960771 FIX: Some attributes of a nested table do not appear in a SQL Server 2008 Data Mining model when the data source is a cube Q960771 KB960771 January 16, 2015
960566 FIX: The chart of a mining model is empty when you browse the mining model in Excel 2007 by using SQL Server 2008 Data Mining Add-ins for Office 2007 Q960566 KB960566 January 16, 2015
960542 FIX: When you run the ALTER TRIGGER statement for a trigger in a merge publication in SQL Server 2005 or in SQL Server 2008, a change is not replicated to the subscriber database Q960542 KB960542 January 16, 2015
959798 FIX: A query that uses a DMV to query the sys.dm_os_performance_counters object seems to stop responding in SQL Server 2008 Q959798 KB959798 January 16, 2015
959784 FIX: Error message when you synchronize data for a transactional publication in SQL Server 2008: "Procedure or function 'sp_MSins_dbo<TableName>_msrepl_ccs' expects parameter '@c7', which was not supplied" Q959784 KB959784 January 16, 2015
959770 FIX: A database contains jumbled column data after you use the SSIS Fuzzy Grouping transformation in SQL Server 2008 Q959770 KB959770 January 16, 2015
959769 FIX: A DMX prediction query returns incorrect results when you query a logistic regression model in SQL Server 2008 Analysis Services Q959769 KB959769 January 16, 2015
959767 FIX: Memory consumption in MEMORYCLERK_SOSNODE and in USERSTORE_SCHEMAMANAGER may cause a performance slowdown of a SQL Server 2008 database Q959767 KB959767 January 16, 2015
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 January 16, 2015
958918 FIX: SQL Server Setup may be unsuccessful when you try to install SQL Server 2008 Q958918 KB958918 January 16, 2015
958793 FIX: The script that the Generate Scripts wizard generates does not include some source database tables Q958793 KB958793 January 16, 2015
958214 FIX: A query returns incorrect results if a passthrough predicate is used with a filter in the query plan Q958214 KB958214 January 16, 2015
958208 FIX: When you call the SQLExecute function to run a query after you set the SQL_ATTR_ROW_ARRAY_SIZE attribute, you may obtain incorrect results in SQL Server 2008 Q958208 KB958208 January 16, 2015
957816 FIX: The Database Mirroring feature does not work on a SQL Server 2008-based mirror server when you perform a rolling upgrade on the mirror server Q957816 KB957816 January 16, 2015
957812 FIX: You cannot merge a publication that has spatial types that include large values with a SQL Server CE subscriber Q957812 KB957812 January 16, 2015
957804 FIX: SQL Server Setup does not use the instance name that you provide in the modified Config.ini file when you try to install SQL Server 2008 Express Q957804 KB957804 January 16, 2015
957458 FIX: SQL Server Setup may incorrectly detect the edition of SQL Server 2008 when you install a SQL Server 2008 failover cluster Q957458 KB957458 January 16, 2015
957330 FIX: Clients cannot connect to the Report Server Web service in SQL Server 2008 Reporting Services Q957330 KB957330 January 16, 2015
957329 FIX: A SQL Server 2008 Reporting Services report runs much slower in the SharePoint integrated mode than in the Native mode Q957329 KB957329 January 16, 2015
957239 FIX: You receive an error message when you click the View Single Column Profile By Column button in the Data Profile Viewer in SQL Server 2008: "Unhandled Exception" Q957239 KB957239 January 16, 2015
957205 FIX: An XML query that contains the @Table variable or the @XML variable takes a long time to complete in SQL Server 2008 Q957205 KB957205 January 16, 2015
956376 FIX: The SQL Server 2005 Distribution Agent and the SQL Server 2008 Distribution Agent do not skip error 20598 when you configure a SQL Server 2000 transactional publication to skip error 20598 Q956376 KB956376 January 16, 2015
955719 FIX: Some text characters are displayed as square glyphs in a report that you design or view by using SQL Server 2008 Reporting Services Q955719 KB955719 January 16, 2015
973302 FIX: Error message when you capture a SQL Server trace file in SQL Server 2008: "Non-yielding Scheduler" Q973302 KB973302 January 15, 2015
972207 FIX: The value of the Size property of the Smo.Server(<serverName>).Databases collection is incorrect after you install Microsoft SQL Server 2008 Service Pack 1 Q972207 KB972207 January 15, 2015
972101 FIX: Error message when you process a very big dimension by using the Process Update option in SQL Server 2008: "File system error: While attempting to read information from disk, a read error occurred for physical file: <filename>, logical ... Q972101 KB972101 January 15, 2015
971985 FIX: A Drillthrough action inside table groups passes incorrect parameter values in SQL Server 2008 Reporting Services Q971985 KB971985 January 15, 2015
971914 FIX: Error message when you run a multithreaded application that uses SQL Server Management Objects (SMO) version 10.00: "An item with the same key has already been added" Q971914 KB971914 January 15, 2015
967161 FIX: Error message when you try to export a SQL Server 2008 Reporting Services report to a PDF file: "Index was out of range" Q967161 KB967161 January 15, 2015
965217 FIX: An incorrect backup set is listed when you restore a database from a backup file by using SQL Server Management Studio in SQL Server 2005 or in SQL Server 2008 Q965217 KB965217 January 15, 2015
2963668 FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitions Q2963668 KB2963668 September 30, 2014
2920987 FIX: Poor performance when many table-valued parameters are used in SQL Server Q2920987 KB2920987 September 30, 2014
2888996 FIX: Data purity corruption in sys.sysbinobjs table in master database when you log on to SQL Server by using the SA account and then run DBCC CHECKDB Q2888996 KB2888996 September 30, 2014
2952260 FIX: New FILESTREAM Filegroup can’t be recognized when you alter a partition function with SPLIT RANGE in SQL Server Q2952260 KB2952260 September 15, 2014
2862883 FIX: SQL Server performance issues in NUMA environments Q2862883 KB2862883 September 11, 2014
981973 FIX: The data in a custom report item is displayed incorrectly after you export the report to a PDF format file by using the ReportExecutionService.Render method in SQL Server 2008 Reporting Services or SQL Server 2008 R2 Reporting Services Q981973 KB981973 June 21, 2014
980037 FIX: "User '<User>' does not have permission to run DBCC showfilestats for database '<Database Name>'" error message when you try to open the Properties dialog box of a database in SSMS 2008 Q980037 KB980037 June 21, 2014
2567304 FIX: Text is truncated from the DTExec.exe output log file when WshShell.Exec is called if the StdOut stream is redirected Q2567304 KB2567304 May 19, 2014
2605597 FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provider for SQLClient Q2605597 KB2605597 May 15, 2014
2555235 FIX: Time-out error when a mirrored database connection is created by the .NET Framework data provider for SQLClient Q2555235 KB2555235 May 15, 2014
818769 FIX: Trace Flag -T8002 Treats an Affinity Mask Like a Process Affinity Q818769 KB818769 February 27, 2014
959032 FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005 or in SQL Server 2008 Q959032 KB959032 April 23, 2013
972936 FIX: "SqlDumpExceptionHandler: Process <spid> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION." error when you run a query in SQL Server 2012, in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005 Q972936 KB972936 February 18, 2013
2431178 FIX: Error message and the report is not printed from the Report Manager website in SSRS 2008 or SQL Server 2008 R2 if you use Internet Explorer Protected Mode in Internet Explorer 8 Q2431178 KB2431178 February 2, 2013
979778 FIX: You receive an error message when you run a query that uses a parent/child dimension in SSAS 2008 Q979778 KB979778 August 27, 2012
2498839 FIX: A memory error occurs when you perform a full process of a dimension in SSAS 2008 R2 or in SSAS 2008 Q2498839 KB2498839 July 16, 2012
2295244 FIX: You are still prompted to install an RSClientPrint control in SSRS 2008 or SSRS 2008 R2 Q2295244 KB2295244 July 5, 2012
2706518 FIX: The KeepFilesForDays setting does not work in SQL Server 2008 or SQL Server 2008 R2 Reporting Services Q2706518 KB2706518 June 18, 2012
2504524 FIX: "Bad variable type" or "Type mismatch" error when you run an UPDATE CUBE statement that has a custom weighted allocation formula in SSAS 2008 R2 or in SSAS 2008 Q2504524 KB2504524 May 21, 2012
2638932 FIX: Error when you run the ProcessUpdate command against a cube that has partitions that use aggregation designs in SSAS 2008 or in SSAS 2008 R2 Q2638932 KB2638932 April 17, 2012
2661225 FIX: Unable to connect to a data source when you use SQL Server Analysis Services 10.0 OLE DB Provider if you enable the "Automatically detect settings" option in the Connections tab of Internet Explorer Q2661225 KB2661225 April 12, 2012
2137539 FULL or BULK recovery models can provide better data protection and recovery Q2137539 KB2137539 April 2, 2012
2128005 Flight Recorder eanbled for SQL Server Analysis Services Q2128005 KB2128005 April 2, 2012
2253635 FIX: MDX queries experience slow performance when a new SSAS role user connects to the SSAS database in SQL Server 2008 Analysis Services or in SQL Server 2008 R2 Analysis Services Q2253635 KB2253635 March 28, 2012
2673993 FIX: "The index data is damaged" error message when you run an MDX query against a dimension or partition in SSAS 2008 Q2673993 KB2673993 March 19, 2012
2660492 FIX: "Internal error" message when you run an MDX query in SQL Server 2008 Analysis Services Q2660492 KB2660492 January 31, 2012
2635540 FIX: "Incorrect syntax" error message when you use a catalog database whose name contains a special character in SSRS 2008 Q2635540 KB2635540 January 17, 2012
2531172 FIX: "Unable to obtain the current member" error when you run an MDX query in SQL Server 2008 Analysis Services or in SQL Server 2008 R2 Analysis Services Q2531172 KB2531172 January 17, 2012
2510788 FIX: Success message is incorrectly logged when a distributed transaction of an SSIS 2005 package, of an SSIS 2008 package or of an SSIS 2008 R2 package is aborted Q2510788 KB2510788 December 19, 2011
970198 FIX: You receive an incorrect result when you run a query that uses the row_number function in SQL Server 2008 or in SQL Server 2008 R2 Q970198 KB970198 December 19, 2011
2616527 FIX: BIDS 2008 may crash when you use a BDD transformation in a Data Flow task in SSIS 2008 Q2616527 KB2616527 November 29, 2011
2608108 FIX: Me.Value is evaluated incorrectly when it is used to access the Value property of a text box in a SSRS 2008 report if the report has a page header or a page footer Q2608108 KB2608108 October 18, 2011
2563449 FIX: XML Source component incorrectly validates external metadata even though the ValidateExternalMetadata property is set to False in SSIS 2008 R2 Q2563449 KB2563449 October 18, 2011
2535660 FIX: Role membership is synchronized even if the SynchronizeSecurity element is set to the SkipMembership value in SSAS 2008 or in SSAS 2008 R2 Q2535660 KB2535660 October 18, 2011
2620333 FIX: Globals.TotalPages variable returns an incorrect value in a SSRS 2008 R2 report Q2620333 KB2620333 October 17, 2011
2580224 FIX: Incorrect results when you commit the Unpivot transformation to a SSIS package in SSIS 2008 or in SSIS 2008 R2 Q2580224 KB2580224 October 17, 2011
972777 FIX: The SQL Server 2008 Analysis Services and SQL Server 2008 R2 Analysis Services service stops responding when you run an ALTER command on a database while an UPDATE CUBE statement is running on the database Q972777 KB972777 October 17, 2011
974559 FIX: Error message when you run a SQL Server 2008 Integration Services package that uses a configuration table in SQL Server Business Intelligence Development Studio: “The connection "<Connection Name>" is not found” Q974559 KB974559 October 10, 2011
972937 FIX: A performance issue in which SQL Server Management Studio checks the fragmentation data of an index in a large database Q972937 KB972937 October 9, 2011
971780 FIX: You receive an incorrect result when you run a query that uses the LIKE predicate ending in the s% characters Q971780 KB971780 October 9, 2011
957387 FIX: No records may be returned when you call the SQLExecute function to execute a prepared statement and you use the SQL Native Client ODBC Driver in SQL Server 2008 Q957387 KB957387 October 8, 2011
936223 FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name ... Q936223 KB936223 October 8, 2011
979925 FIX: The ddl_event_notification_events notification is registered successfully even when Service Broker is disabled in SQL Server 2008 Q979925 KB979925 October 7, 2011
978791 FIX: Data loss may occur if the database mirroring thread stops responding for a long time during an automatic failover process in SQL Server 2005 or in SQL Server 2008 Q978791 KB978791 October 7, 2011
975565 FIX: The row count is incorrect after you run a "BULK INSERT" statement by using SQL Server JDBC driver 2.0 to insert data into a table Q975565 KB975565 October 7, 2011
969210 FIX: Error messages in various reports in Visual Studio 2008 Team Foundation Server Service Pack 1 with SQL Server 2008 Reporting Services Q969210 KB969210 October 7, 2011
981838 FIX: An MDX query returns an incorrect result when you run the query by using a clean cache in SSAS 2008 Q981838 KB981838 October 6, 2011
980949 FIX: Header rows of a tablix do not always appear at the top of pages in an SSRS 2008 report Q980949 KB980949 October 6, 2011
980252 FIX: An MDX query that references a calculated measure and references a dimension that uses custom rollup formulas returns an incorrect value in SSAS 2008 Q980252 KB980252 October 6, 2011
979740 FIX: Error message when the EMF printing renderer is under stress or when you try to print multiple reports at the same time in SSRS 2008: "System.Exception: SelectClipRgn failed: Win32 error:997" Q979740 KB979740 October 6, 2011
979379 FIX: Charts that are in a tablix of an SSRS 2008 report display incorrect data Q979379 KB979379 October 6, 2011
973968 FIX: A query notification event occurs at incorrect intervals and the time-out setting is not honored when you use query notification that is created by using the SqlDependency object in SQL Server 2008 or in SQL Server 2005 Q973968 KB973968 October 6, 2011
982899 Forms Based Authentication in Reporting Service Q982899 KB982899 October 5, 2011
2591295 FIX: SSAS 2008 or SSAS 2008 R2 crashes when you perform synchronization in TFS 2010 after you rebuild a cube Q2591295 KB2591295 October 4, 2011
2574695 File initialization takes a long time for SQL Server database-related operations Q2574695 KB2574695 August 30, 2011
968829 FIX: Error message when you try to upgrade an instance of SQL Server 2005 to SQL Server 2008: "Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes" Q968829 KB968829 July 29, 2011
955695 FIX: When you run a Transact-SQL script in a step of a SQL Server Agent job in SQL Server 2005 or in SQL Server 2008, the result of the Transact-SQL script may be truncated Q955695 KB955695 June 16, 2011
2983564 FIX: Error message when you use database mirroring in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2, and an assertion failure occurs intermittently Q2983564 KB2983564 May 30, 2011
983564 FIX: Error message when you use database mirroring in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2, and an assertion failure occurs intermittently Q983564 KB983564 May 30, 2011
978839 FIX: A backup operation on a SQL Server 2008 database fails if you enable change tracking on this database Q978839 KB978839 May 26, 2011
974319 FIX: Intermittent error message and assertion failure when you use database mirroring in SQL Server 2005, in SQL Server 2008, or in SQL Server 2008 R2: "SQL Server Assertion: File: <loglock.cpp>, line=823 Failed Assertion = 'result == LCK_OK'" Q974319 KB974319 April 29, 2011
2216501 FIX: Multiserver jobs are not downloaded from SQL Server 2000 in the MSX role to SQL Server 2008 or to SQL Server 2008 R2 in the TSX role Q2216501 KB2216501 April 22, 2011
2216497 FIX: Spatial Storage geometry polygon data types with internal rings return incorrect data through different geometric operations Q2216497 KB2216497 April 22, 2011
2497585 FIX: Incorrect newsletter-style report when a text box value extends from one column to another in SSRS 2008 if you use hard-page-break renderer format Q2497585 KB2497585 March 21, 2011
2481245 FIX: PivotTable report might return no values after you apply a complex filter in SSAS 2008 or in SSAS 2008 R2 Q2481245 KB2481245 March 21, 2011
2480368 FIX: SSAS 2008 or SSAS 2008 R2 crashes after a ProcessFull operation is performed on a measure group for a server-based cube if SSAS tries to clean a session that contains a session cube Q2480368 KB2480368 March 21, 2011
2478032 FIX: 0xC002F325 error when you run two SSIS 2008 packages at the same time in SQL Server 2008 Integration Services or in SQL Server 2008 R2 Integration Services Q2478032 KB2478032 March 21, 2011
2401548 FIX: An embedded image of a report is incorrectly displayed as a red cross in SQL Server 2008 Reporting Services and in SQL Server 2008 R2 Reporting Services Q2401548 KB2401548 March 21, 2011
976124 FIX: After you install SQL Server 2008 SP1 for the IA-64 version of SQL Server 2008 with Event Tracing for Windows (ETW) installed, SQL Server hangs during startup and cannot be started Q976124 KB976124 March 9, 2011
2479681 FIX: "An item with the same key has already been added" error when you export a report to a PDF or TIFF file in SQL Server 2008 Reporting Services and in SQL Server 2008 R2 Reporting Services Q2479681 KB2479681 February 21, 2011
2454175 FIX: Wrong email subscription is deleted when you use the SharePoint Integrated mode in SSRS 2008 or in SSRS 2008 R2 if you sort the email subscriptions Q2454175 KB2454175 February 21, 2011
2422081 FIX: The memory usage in SSAS 2008 or SSAS 2008 R2 may be larger than in SSAS 2005 when you create a local cube Q2422081 KB2422081 February 21, 2011
980350 FIX: Polish word breaker causes a Full-Text query to return an incomplete result in SQL Server 2008 or in SQL Server 2008 R2 Q980350 KB980350 February 21, 2011
2446498 FIX: "An error occurred during local report processing" error message may occur when you export a report in SQL Server 2008 Reporting Services Q2446498 KB2446498 January 17, 2011
2431212 FIX: MHTML-formatted reports are not compliant with section 1194.22 of the Electronic and Information Technology Accessibility Standards when you use SSRS 2008 or SSRS 2008 R2 to generate the report Q2431212 KB2431212 January 17, 2011
2430162 FIX: "The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples" error message occurs when you try to run an MDX query in SSAS 2008 or in SSAS 2008 R2 Q2430162 KB2430162 January 17, 2011
2276495 FIX: "File system error" occurs when you try to run a process update operation on a dimension in Microsoft SQL Server 2008 Analysis Services and in Microsoft SQL Server 2008 R2 Analysis Services Q2276495 KB2276495 January 17, 2011
2263904 FIX: The application stops responding for 100 seconds and then a SoapException exception occurs after an application calls the ReportExecutionService.Render2 method in SQL Server 2008 Reporting Services Q2263904 KB2263904 January 17, 2011
2983500 FIX: The role synchronization process is delayed when a mirroring automatic failover occurs in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2983500 KB2983500 December 22, 2010
983500 FIX: The role synchronization process is delayed when a mirroring automatic failover occurs in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q983500 KB983500 December 22, 2010
2292725 FIX: You experience decreased performance when you run an MDX query in SQL Server 2008 SP1 or in SQL Server 2008 R2 that has cumulative update 5 or a later version of the update package installed Q2292725 KB2292725 December 20, 2010
2222267 FIX: Complex calculations in a query in SQL Server 2008 Analysis Services or in SQL Server 2008 R2 Analysis Services return incorrect results Q2222267 KB2222267 December 20, 2010
982564 FIX: You cannot run Data Profile Viewer to open a data profile in SQL Server 2008 or in SQL Server 2008 R2 when the server does not have the Integration Services component installed Q982564 KB982564 December 20, 2010
975860 FIX: A full backup with snapshot may cause SQL Server 2005 or SQL Server 2008 to stop responding Q975860 KB975860 December 15, 2010
2983577 FIX: The export process never finishes when you export a report that has nested tablix items in SSRS 2008 or in SSRS 2008 R2 to the extensions that are supported by the hard page-break renderers Q2983577 KB2983577 November 15, 2010
2983480 FIX: Various issues occur when a database is involved in a database mirroring session and in a transactional replication if trace flag 1448 is enabled Q2983480 KB2983480 November 15, 2010
2983429 FIX: A deadlock occurs when you run a query or a stored procedure that contains an XML column in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2983429 KB2983429 November 15, 2010
2248999 FIX: An index corruption occurs when you update a view in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q2248999 KB2248999 November 15, 2010
2222998 FIX: An incorrect cardinality estimate is returned when you run a query in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2222998 KB2222998 November 15, 2010
2220252 FIX: A SQL Server 2005 report that uses the visibility toggles feature runs incorrectly in SQL Server 2008 or in SQL Server 2008 R2 Q2220252 KB2220252 November 15, 2010
2200755 FIX: Error message when you run a MDX query in SSAS 2008 or in SSAS 2008 R2 Q2200755 KB2200755 November 15, 2010
2028755 FIX: An incorrect result is returned when you run a LIKE query with wildcards and the Latin1_General_100_CS_AS collation in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q2028755 KB2028755 November 15, 2010
2028406 FIX: Blank spaces between some items are generated incorrectly in a SQL Server 2008 or a SQL Server 2008 R2 report Q2028406 KB2028406 November 15, 2010
983577 FIX: The export process never finishes when you export a report that has nested tablix items in SSRS 2008 or in SSRS 2008 R2 to the extensions that are supported by the hard page-break renderers Q983577 KB983577 November 15, 2010
983480 FIX: Various issues occur when a database is involved in a database mirroring session and in a transactional replication if trace flag 1448 is enabled Q983480 KB983480 November 15, 2010
983429 FIX: A deadlock occurs when you run a query or a stored procedure that contains an XML column in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q983429 KB983429 November 15, 2010
982363 FIX: SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 may require a long time to complete an ALTER TABLE statement that alters an XML data type column from "NOT NULL" to "NULL" in a table Q982363 KB982363 November 15, 2010
982034 FIX: The translation feature does not work when you perform a grouping action in an Excel PivotTable that uses SSAS 2008 or SSAS 2008 R2 as the data source Q982034 KB982034 November 15, 2010
981888 FIX: "Deadlock monitor failed to resolve this deadlock. Server may require restart to recover from this condition" error message when a database is being recovered in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 Q981888 KB981888 November 15, 2010
981867 FIX: A calculated member that uses filtered dimension members returns an incorrect result in SSAS 2005, SSAS 2008 R2 or SSAS 2008 Q981867 KB981867 November 15, 2010
981713 FIX: A query returns an incorrect result if it uses an index that is being rebuilt online in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008 Q981713 KB981713 November 15, 2010
981502 FIX: A query that uses a parallel query plan returns different results every time that you run the query in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008 Q981502 KB981502 November 15, 2010
981120 FIX: Error message when you enable TDE on a database that has the snapshot isolation enabled in SQL Server 2008 or in SQL Server 2008 R2 Q981120 KB981120 November 15, 2010
980948 FIX: Metadata is corrupted when you move SSAS 2005, SSAS 2008 R2 or SSAS 2008 data folders from one computer to another computer Q980948 KB980948 November 15, 2010
980883 FIX: Proactive caching starts unexpectedly when you insert data in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008 Q980883 KB980883 November 15, 2010
980570 FIX: "Fulltext index error during compression or decompression" error message when you rebuild the full-text search index in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q980570 KB980570 November 15, 2010
2216454 FIX: Error message when you run the ProcessAdd command after you make changes to the partition on a server that is running SQL Server 2008 Analysis Services: "Internal Error: An unexpected exception occurred" Q2216454 KB2216454 September 14, 2010
981881 FIX: "The selected data extension <data extension name> cannot be loaded" error message when you use Report Builder 2.0 to run an SSRS 2008 or SSRS 2008 R2 report that uses a custom data processing extension in server mode Q981881 KB981881 August 16, 2010
981814 FIX: SSMS Object Explorer does not display the correct version number for SSIS or for SSRS Q981814 KB981814 August 16, 2010
981811 FIX: An error occurs when you update the schema of objects that are in a published database in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 Q981811 KB981811 August 16, 2010
2231277 FIX: The Reporting Services service stops unexpectedly after you apply SQL Server 2008 SP1 CU 7 or CU8 Q2231277 KB2231277 July 30, 2010
2184384 FIX: MDX query triggers a "#Error CellPermission (1, 5) The MDX function CURRENTMEMBER failed" error in SQL Server 2008 Analysis Services Q2184384 KB2184384 July 21, 2010
2216484 FIX: Error message when you export a report to Excel in Report Manager on a server that is running SQL Server 2008: "Unhandled managed exception: Type = System.ArgumentOutOfRangeException" Q2216484 KB2216484 July 8, 2010
2216480 FIX: The margins are not retained in a report when the report is exported to Excel on a server that is running SQL Server 2008, and then you preview the report in Excel Q2216480 KB2216480 July 8, 2010
2216474 FIX: You may experience some loss of data when you use an UPDATE statement with a SET clause that uses the time, datetime2 and datetimeoffset types in SQL Server 2008 Q2216474 KB2216474 July 8, 2010
2983286 FIX: "A connection cannot be made" error message in SSAS 2008 or SSAS 2008 R2 when you try to connect to a database Q2983286 KB2983286 June 23, 2010
982662 FIX: You receive error code 0xC0024104 and error code 0xC0024104 when you run a maintenance plan that contains a Backup task in SQL Server 2005 Q982662 KB982662 June 23, 2010
982631 FIX: A SQL Server 2008 Reporting Services or SQL Server 2008 R2 Reporting Services report that contains a table with a child group does not comply with the Section 508 standards Q982631 KB982631 June 23, 2010
982418 FIX: "An unexpected error occurred" error message when you use the OPENROWSET function to access an SSAS 2008 or SSAS 2008 R2 database Q982418 KB982418 June 23, 2010
982417 FIX: A query returns incorrect results for the ChildCount, DrilledDown, and ParentSameAsPrevious properties of a calculated member in SSAS 2008 or SSAS 2008 R2 Q982417 KB982417 June 23, 2010
982321 FIX: Error message when you process an index of a partition in SSAS 2008 or SSAS 2008 R2 Q982321 KB982321 June 23, 2010
981922 FIX: An assertion failure occurs when you run a parameterized query that has many parameters in SQL Server 2008 or SQL Server 2008 R2 and that has the SHOWPLAN_XML option enabled Q981922 KB981922 June 23, 2010
981899 FIX: An exception occurs when you filter or run an MDX query on a database that contains a dynamic set in SSAS 2008 or SSAS 2008 R2 Q981899 KB981899 June 23, 2010
981626 FIX: An unhandled managed exception occurs when you try to export an SSRS 2008 report to an Excel format Q981626 KB981626 May 17, 2010
968742 FIX: Error message when you rebuild a table that has sparse columns in SQL Server 2008: "Cannot alter table '<TableName>' because the table either contains sparse columns or a column set column which are incompatible with compression" Q968742 KB968742 May 17, 2010
958792 FIX: Error message when you rebuild indexes for a table that contains sparse columns in SQL Server 2008: "Cannot alter table '<TableName>' because the table either contains sparse columns or a column set column which are incompatible with compression" Q958792 KB958792 May 17, 2010
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 May 13, 2010
957803 FIX: You cannot start the Data Profile Viewer (DataProfileViewer.exe) in SQL Server 2008 Q957803 KB957803 April 15, 2010
975171 FIX: You cannot synchronize binary large object (BLOB) data by using a transactional replication when you set the SubscriptionStreams parameter of the Distribution Agent to a value that is larger than 1 in SQL Server 2008 Q975171 KB975171 March 18, 2010
980930 FIX: A perspective unexpectedly displays dimensions and measures that were not specified when you view the perspective in Report Builder versions 1.0 or 2.0 in SQL Server 2008 Q980930 KB980930 March 15, 2010
980406 FIX: A query on a SQL Server 2008 database snapshot fails after the source database is restarted Q980406 KB980406 March 15, 2010
979774 FIX: Policy-Based Management incorrectly applies a policy evaluation to all target types in SQL Server 2008 Q979774 KB979774 March 15, 2010
979577 FIX: SQL Server 2008 clustered resources cannot come online if you have enabled the FILESTREAM feature for Transact-SQL access Q979577 KB979577 March 15, 2010
979496 FIX: Log entries are missing for the OnPreExecute event and the OnPostExecute event in SQL Server 2008 Integration Services Q979496 KB979496 March 15, 2010
978930 FIX: A parameter value is replaced by its default value when the parameter is hidden and in a snapshot report in SQL Server 2008 Reporting Services Q978930 KB978930 March 15, 2010
978894 FIX: Error message when you use Query Builder to modify an existing query of an SSRS 2008 report: "The Query designer cannot load due to a problem with the selected cube <cube name>" Q978894 KB978894 March 15, 2010
979707 FIX: A distributed transaction is aborted unexpectedly in SQL Server 2008 Q979707 KB979707 March 9, 2010
970160 FIX: The data collector is disabled after you install an update for an instance of SQL Server 2008 Q970160 KB970160 February 1, 2010
970150 FIX: Error message when you open Replication Monitor for a transactional or merge publication in an instance of SQL Server 2008 that is an upgrade from SQL Server 2000: "Cannot insert the value NULL into column 'isagentrunningnow'" Q970150 KB970150 February 1, 2010
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
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
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
976761 FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster : "18401, Login failed for user SQLTEST\AgentService. Reason: Server is in script upgrade mode. Only administrator can connect at this time.[SQLState 42000]" Q976761 KB976761 December 21, 2009
976367 FIX: The Date data type may be corrupted when you use the SAP BI Destination component of Microsoft Connector 1.0 for SAP BI in a SQL Server 2008 Integration Services package Q976367 KB976367 November 26, 2009
974766 FIX: Error message when you run a parallel query in SQL Server 2008: "Trying to use the transaction while there are 1 parallel nested xacts outstanding" Q974766 KB974766 November 24, 2009
974231 FIX: Some files are not rolled back to the original file versions after you uninstall a SQL Server 2008 Service Pack 1 hotfix that is applied when you use a slipstream installation Q974231 KB974231 November 24, 2009
972687 FIX: Error message when you restore a SQL Server 2000 database by using SQL Server 2005 Management Studio or SQL Server 2008 Management Studio: "Cannot show requested dialog. Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)" Q972687 KB972687 November 24, 2009
971136 FIX: Error message when you synchronize a database or manually run sp_replcmds after you perform partial updates on a varbinary(max) column in SQL Server 2008: "The rowset does not contain any column with offset -1." Q971136 KB971136 November 24, 2009
969050 FIX: Error message when you run a SQL Server 2008 Integration Services package that contains an Execute SQL Task that runs a stored procedure: "The type of the value being assigned to variable "<Variable>" differs from the current variable type" Q969050 KB969050 November 24, 2009
968543 FIX: Error message is logged in the SQL Server 2008 Errorlog file when you perform operations on some temporary tables in SQL Server 2008: "Time out occurred while waiting for buffer latch" Q968543 KB968543 November 24, 2009
975772 FIX: An access violation occurs intermittently during message processing for service broker, and the session may be disconnected in SQL Server 2008 Q975772 KB975772 November 17, 2009
977058 FIX: Cascading parameters have incorrect values after you customize the schedule for a new subscription on a SharePoint site of SQL Server 2008 Reporting Services Q977058 KB977058 November 16, 2009
976935 FIX: The execution of a parameterized CTE-based query takes a long time to complete in SQL Server 2008 Q976935 KB976935 November 16, 2009
976603 FIX: Different results may be returned when you concurrently run the same query with the RECOMPILE option in SQL Server 2008 Q976603 KB976603 November 16, 2009
976414 FIX: Full-text search functionality does not work in SQL Server 2008 Express Edition even after you installed SQL Server 2008 CU2 Q976414 KB976414 November 16, 2009
976413 FIX: Error message in SQL Server 2008 when you try to transfer data by using a Transfer object that has the WithDependencies property enabled: "Object reference not set to an instance of an object." Q976413 KB976413 November 16, 2009
976391 FIX: A MDX query that involves multiple calculated measures may return an incorrect result in SQL Server 2008 Analysis Services Q976391 KB976391 November 16, 2009
976359 FIX: Error message when you export a report that uses the Code39(1:3) font to a .pdf file in SQL Server 2008 Reporting Services: “There was an error processing a page. There was a problem reading this document(135)” Q976359 KB976359 November 16, 2009
976030 FIX: Error message after you perform a Process Update on a dimension used on a cube that contains a writeback partition: "Errors in the high-level relational engine. The data source view does not contain a definition for the <tablename> table or view" Q976030 KB976030 November 16, 2009
975756 FIX: Toggled items display incorrectly when you print or export a SQL Server 2008 Reporting Services report Q975756 KB975756 November 16, 2009
975719 FIX: An assertion failure may occur when you run a query that joins columns on a table with compression enabled in SQL Server 2008 Q975719 KB975719 November 16, 2009
975284 FIX: The mean and median lines are not shown when you view a report that contains a Boxplot chart in SQL Server 2008 Reporting Services Q975284 KB975284 November 16, 2009
974130 FIX: A memory leak may occur if you use a linked server query to retrieve a sql_variant column from a remote server in SQL Server 2005 or in SQL Server 2008 Q974130 KB974130 November 16, 2009
976953 FIX: The SQL Server 2008 agent does not automatically resume running after you upgrade to SQL Server 2008 CU7 or SQL Server 2008 SP1 CU3/CU4 in a stand-alone environment Q976953 KB976953 November 13, 2009
975783 FIX: You receive an incorrect result when you run an MDX query against a dimension that has a parent/child relationship after you install a cumulative update in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q975783 KB975783 November 3, 2009
975134 FIX: Capitalization and accent changes on a column of user-defined data type are not propagated in SQL Server 2005 merge replication or in SQL Server 2008 merge replication Q975134 KB975134 October 23, 2009
974785 FIX: An API cursor plan that is created by a plan guide is not reused when the cursor is active in SQL Server 2005 and in SQL Server 2008 Q974785 KB974785 October 23, 2009
975159 FIX: For SQL Server Compact Edition (CE) Subscribers, only schema without data is replicated for newly added articles to an existing Merge Publication using “ExchangeType.Upload” Q975159 KB975159 October 22, 2009
976041 FIX: You receive an incorrect result when you run a query that uses a parallel execution plan in SQL Server 2005 or in SQL Server 2008 Q976041 KB976041 October 19, 2009
975748 FIX: You cannot process an object when you change or delete another unrelated object at the same time in the same database in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q975748 KB975748 October 19, 2009
975417 FIX: A SELECT statement returns an incorrect result set if a linked server is being used in SQL Server 2005 or in SQL Server 2008 Q975417 KB975417 October 19, 2009
975089 FIX: The restore operation takes a long time when you restore a database that has query notification enabled in SQL Server 2005 or in SQL Server 2008 Q975089 KB975089 October 19, 2009
974777 FIX: Database restore operation may fail during the recovery phase when the database uses query notification in SQL Server 2005 or in SQL Server 2008 Q974777 KB974777 October 19, 2009
974067 FIX: You use the COUNT function on a column that is returned by a subquery that returns no rows in SQL Server 2005 or in SQL Server 2008, and an incorrect result is returned Q974067 KB974067 October 19, 2009
973643 FIX: The synchronization of a merge publication that uses Web synchronization takes a very long time to finish after the initial synchronization in SQL Server 2005 or in SQL Server 2008 Q973643 KB973643 October 19, 2009
957821 FIX: The data fields for certain actions are empty when you configure a SQL Server 2008 Extended Event session that captures data from certain events Q957821 KB957821 October 13, 2009
973090 FIX: Prefix search with extended characters or accents returns incorrect result in SQL Server 2008 Q973090 KB973090 September 24, 2009
974712 FIX: Error message when you use the BCP utility with the -R option in SQL Server 2008 to load a file that contains the dates of the non-English format: "[Microsoft][SQL Server Native Client 10.0]Invalid date format" Q974712 KB974712 September 22, 2009
974404 FIX: A subreport does not appear if you set the MergeTransactions property of the subreport to "True" in SQL Server 2008 Reporting Services Q974404 KB974404 September 22, 2009
974276 FIX: Error message when you preview a report in Report Builder 2.0 when the Report server uses Basic Authentication: "The request failed with HTTP status 401: Unauthorized." Q974276 KB974276 September 22, 2009
973897 FIX: The Database Mirroring session is disconnected when you manually perform a failover in SQL Server 2008 Q973897 KB973897 September 22, 2009
973580 FIX: A query that uses the WITH CUBE aggregation incorrectly returns NULL values when you set the ANSI_WARNINGS option to "ON" in SQL Server 2008 Analysis Services Q973580 KB973580 September 22, 2009
973300 FIX: Error message when you resize a Chart control in the Report Designer in SQL Server 2008 Business Intelligence Development Studio on a computer that is running Windows 7: "Chart Exception: Parameter is not valid." Q973300 KB973300 September 22, 2009
973292 FIX: Error message when you use Microsoft Connector 1.0 for SAP BI in a SQL Server 2008 Integration Services package to extract data from SAP BW: "System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown" Q973292 KB973292 September 22, 2009
973255 FIX: When you run a query that uses the MIN or MAX function against a partitioned view in SQL Server 2008, the query runs much slower than when you run the same query in SQL Server 2005 Q973255 KB973255 September 22, 2009
973103 FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005 or SQL Server 2008:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect" Q973103 KB973103 September 22, 2009
972939 FIX: A validation error is returned when you use the MSOLAP10 provider to connect to a SQL Server 2008 R2 Analysis Services server and set the value of the SubQueries property to 2 in the connection string Q972939 KB972939 September 22, 2009
975414 FIX: The connection information is incorrect after you use "Change Connection" to connect to another server before the initial connection is completed in SQL Server Management Studio in SQL Server 2008 Q975414 KB975414 September 21, 2009
975037 FIX: Error message when two or more merge agents are trying to adjust a publisher identity range in parallel in SQL Server 2008: "Msg 548, The insert failed. It conflicted with an identity range check constraint" Q975037 KB975037 September 21, 2009
974816 FIX: You cannot add a node to a SQL Server 2008 cluster by running the Setup program if there are multiple instances of different languages installed on the same node Q974816 KB974816 September 21, 2009
974398 FIX: The removal of a transaction log file from the database on the principal server causes a database mirroring session to be suspended in SQL Server 2005 or in SQL Server 2008 Q974398 KB974398 September 21, 2009
974262 FIX: After you merge the partitions of a table that have the data compression option enabled, and then re-partition the table, the data compression option is disabled on one of the table partitions in SQL Server 2008 Q974262 KB974262 September 21, 2009
974036 FIX: A specified collation is displayed incorrectly when you use the Advanced/Enterprise installation mode to install a SQL Server 2008 failover cluster through the GUI Q974036 KB974036 September 21, 2009
973257 FIX: The SQL:BatchCompleted event and the RPC:Completed event displays an incorrect row count when you use SQL Server Profiler to monitor a sp_executesql stored procedure call in Microsoft SQL Server 2008 Q973257 KB973257 August 26, 2009
973877 FIX: A performance issue in which you run a query by using a Fast Forward cursor in SQL Server 2005 or SQL Server 2008 Q973877 KB973877 August 17, 2009
972681 FIX: The removal of a transaction log file of the database on the principal server breaks a database mirroring session in SQL Server 2005 or in SQL Server 2008 Q972681 KB972681 August 17, 2009
972271 FIX: Error message when you run a "BULK INSERT" statement on a table that does not have a clustered index in SQL Server 2005 or SQL Server 2008: "spid1005 Error: 5243, Severity: 22, State: 1 An inconsistency was detected during an internal operation" Q972271 KB972271 August 17, 2009
971057 FIX: An INSERT INTO <table name> EXEC <stored procedure name> statement generates error messages even if you set the ANSI_WARNINGS option to "OFF" in SQL Server 2005 and SQL Server 2008 Q971057 KB971057 August 17, 2009
969086 FIX: The SQL Server service stops responding, and event ID 2019 is logged in the System log in SQL Server 2005 or in SQL Server 2008 Q969086 KB969086 August 11, 2009
968615 FIX: SQL Server Integration Services Import and Export Wizard does not provide the ConnectionString property for the .NET Framework Data Provider for ODBC Q968615 KB968615 August 7, 2009
972856 FIX: Some columns are missing when you run a query against a table that is located on a linked server if the column names contain a period character in SQL Server 2008 Service Pack 1 Q972856 KB972856 July 30, 2009
972763 FIX: The queries run very slowly when you run MDX queries in an application that uses the ADOMD.NET data provider through HTTP to connect to SQL Server 2008 Analysis Services Q972763 KB972763 July 27, 2009
970666 FIX: The data of a text box is missing when you print or export a SQL Server 2008 Reporting Services report that contains one or more subreports and one or more text boxes Q970666 KB970666 July 27, 2009
970044 FIX: Error message when you try to break database mirroring between two servers that are running SQL Server 2008: "Non-yielding Scheduler" Q970044 KB970044 July 27, 2009
973192 FIX: Error message when you create a local cube by using the SQL Server 2008 ADOMD.NET data provider in the x64-based version of Microsoft Office 2010: "Failed to initialize provider object" Q973192 KB973192 July 24, 2009
970507 FIX: Error message in SQL Server 2008 when you run an INSERT SELECT statement on a table: "Violation of PRIMARY KEY constraint '<PrimaryKey>'. Cannot insert duplicate key in object '<TableName>'" Q970507 KB970507 July 24, 2009
973250 FIX: A specified collation is displayed incorrectly when you use the Advanced/Enterprise installation mode to install a SQL Server 2008 failover cluster through the GUI Q973250 KB973250 July 21, 2009
973204 FIX: A change to the Maximum File Size property on a large database takes a long time to finish in SQL Server 2008 Management Studio Q973204 KB973204 July 21, 2009
972984 FIX: You receive an incorrect result when you query a parent/child hierarchy that contains a single member on a level in Microsoft SQL Server 2008 Analysis Services Q972984 KB972984 July 21, 2009
972650 FIX: Error message when you run a full-text query in SQL Server 2008 after you register an IFilter: "No appropriate filter was found during full-text index population for table or indexed view" Q972650 KB972650 July 21, 2009
972521 FIX: SQL Server 2008 Reporting Services does not deliver a report that contains a line chart of the Stepped Line chart type at the scheduled time Q972521 KB972521 July 21, 2009
972440 FIX: Data is missing when you display a SQL Server 2008 Reporting Services report that is exported as a PDF file or as an image Q972440 KB972440 July 21, 2009
972203 FIX: Error message when you press F1 to open the Device Contents help during a restore operation in SQL Server 2008: "Object reference not set to an instance of an object. (DqlManagerUI)" Q972203 KB972203 July 21, 2009
972201 FIX: The “Copy Only Backup” option is still available even though you select the “Differential” option in the “Back Up Database” dialog box in SQL Server 2008 Management Studio Q972201 KB972201 July 21, 2009
972198 FIX: Error message when you try to add a filter for an included column index in SQL Server 2008: "Add object to collection failed for IndexedColumnCollection of Index '<IndexName>'" Q972198 KB972198 July 21, 2009
972197 FIX: When you query the DataSpaceUsed property or the IndexSpaceUsed property of a database that contains many tables in SQL Server 2008, the query takes a long time to finish Q972197 KB972197 July 21, 2009
971772 FIX: Error message when you process a partition in a measure group in SQL Server 2008 Analysis Services: "Errors in the high-level relational engine. The binding for the '<ColumnName>' column is not a ColumnBinding type" Q971772 KB971772 July 21, 2009
971640 FIX: You cannot set up Data Collector on a SQL Server 2008 server if the server has a database that cannot be accessed or only allows restricted access Q971640 KB971640 July 21, 2009
971064 FIX: Quotation marks are rendered incorrectly when you export a SQL Server 2008 Reporting Services report to a .csv file Q971064 KB971064 July 21, 2009
971049 FIX: Error message when you run a SQL Server 2008 Reporting Services report in Business Intelligence Development Studio: "An item with the same key has already been added" Q971049 KB971049 July 21, 2009
970966 FIX: An MDX query that uses the NON EMPTY clause and the DrillDownLevel function returns null values in SQL Server 2005 Analysis Services or SQL Server 2008 Analysis Services Q970966 KB970966 July 21, 2009
970909 FIX: You receive an incorrect result when you run a full-text query that combines the NEAR operator together with the AND operator in SQL Server 2008 Q970909 KB970909 July 21, 2009
970823 FIX: CPU usage increases when you run a query that uses a string comparison function on a computer that has many processors after you upgrade to SQL Server 2005 Service Pack 3 or to SQL Server 2008 Q970823 KB970823 July 21, 2009
970713 FIX: A policy is evaluated against an incorrect target when you run the policy category in evaluation mode on a remote server that is running SQL Server 2008 Q970713 KB970713 July 21, 2009
970551 FIX: Error message when you run an MDX query that requests a dimension property on a parent-child hierarchy in Microsoft SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q970551 KB970551 July 21, 2009
970538 FIX: Error message when you process the index for a partition in a cube in Microsoft SQL Server 2008 Analysis Services: "Internal error: An unexpected error occurred (file 'pffilestorefilegroup.cpp', line 1483, function 'PFFileStoreGroup::ReadPage')" Q970538 KB970538 July 21, 2009
970133 FIX: When you create a compressed backup for a database in SQL Server 2008, you cannot stop the backup operation if the backup operation stops responding Q970133 KB970133 July 21, 2009
970058 FIX: Error message when you open a report by specifying a multivalued parameter in a URL in SQL Server 2005 or SQL Server 2008 Reporting Services: "Default value or value provided for the report parameter '<Parameter>' is not a valid value" Q970058 KB970058 July 21, 2009
970014 FIX: The Management Data Warehouse database grows very large after you enable the Data Collector feature in SQL Server 2008 Q970014 KB970014 July 21, 2009
969844 FIX: You receive inconsistent results when you run index-related DMVs to return statistical information about missing indexes in SQL Server 2005 or in SQL Server 2008 Q969844 KB969844 July 21, 2009
969528 FIX: An assertion failure occurs when you switch the schedule of a report subscription between a shared schedule and a custom schedule in SQL Server 2005 Report Services or SQL Server 2008 Reporting Services Q969528 KB969528 July 21, 2009
969467 FIX: Error message when you run a query that uses the CASE function in SQL Server 2008: "Conversion failed when converting the <Type1> value ‘<A value>’ to data type <Type2>." Q969467 KB969467 July 21, 2009
969357 FIX: SQL Server 2008 Report Designer renders numbers in an order opposite to what you expect when you add a special character to a Textbox control that contains both Hebrew characters and numbers Q969357 KB969357 July 21, 2009
968740 FIX: Error message when you perform an online index rebuild operation for a table that has no clustered index in SQL Server 2008: "Location: pageref.cpp:913 Expression: IS_OFF" Q968740 KB968740 July 21, 2009
967522 FIX: The SQL Server engine in SQL Server 2005 and in SQL Server 2008 may consume large amounts of memory during the setup configuration phase Q967522 KB967522 July 21, 2009
967315 FIX: You receive an incorrect result when you run a full-text query against a table that uses the Chinese word breaker in SQL Server 2008 Q967315 KB967315 July 21, 2009
956574 FIX: Data results are inconsistent in SQL Server 2005 and in SQL Server 2008 when you run a search query that uses the NEAR operator against an XML type data that contains the xml:lang attribute Q956574 KB956574 July 21, 2009
970349 FIX: Queries from a query notification that has a lot of subscriptions run slowly when you change the Auto Close option to False in SQL Server 2005 or in SQL Server 2008 Q970349 KB970349 June 16, 2009
968900 FIX: Measures, measure groups, and dimensions that are not part of a perspective are exposed incorrectly when you create a grouping on the perspective in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q968900 KB968900 June 16, 2009
967470 FIX: Error message when you perform an update or a delete operation on a table that does not have a clustered index created in SQL Server 2005 and in SQL Server 2008: "The operating system returned error 1450" Q967470 KB967470 June 16, 2009
967164 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 and in SQL Server 2008 Q967164 KB967164 June 16, 2009
971125 FIX: The Data Profiling task shows "is_nullable" in the Control Flow window after you configure the Data Profiling task for a data source that uses the Turkish_CI_AS or Turkish_CS_AS collation in SQL Server 2008 Integration Services Q971125 KB971125 May 18, 2009
970461 FIX: An MDX query that contains the Aggregate function incorrectly returns a NULL value for a calculated measure in SQL Server 2008 Analysis Services Q970461 KB970461 May 18, 2009
970255 FIX: Error message when you create a report that uses a SAP NetWeaver BI data source in SQL Server 2008 Reporting Services: "The method specified is not supported by the current provider. (Microsoft Visual Studio)" Q970255 KB970255 May 18, 2009
970184 FIX: You receive a "File system error" error message that mentions a temporary file when you process a cube in SQL Server 2008 Analysis Services Q970184 KB970184 May 18, 2009
969653 FIX: All SQL Server 2008 database engine performance counters appear to be missing when you try to monitor the performance counters through WMI interfaces Q969653 KB969653 May 18, 2009
969588 FIX: Some cell values are doubled when you run an MDX query against a database that has the AllowedSet permission set for a dimension in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q969588 KB969588 May 18, 2009
969513 FIX: When you read an input column by using the managed code within a script component in a SQL Server 2008 Integration Services package, some meaningless characters are added to the returned data Q969513 KB969513 May 18, 2009
969453 FIX: The cascading report parameters are inconsistent in a SQL Server 2008 Reporting Services report that contains three or more levels of cascading report parameters Q969453 KB969453 May 18, 2009
969235 FIX: Error message when you run an MDX query in SQL Server 2008 Analysis Service: "The Extract function was called with hierarchy '' that does not exist in the set" Q969235 KB969235 May 18, 2009
969131 FIX: When you design a SQL Server 2008 report in Visual Studio 2008, no data is returned for a dataset that retrieves data from an XML Web Service by using a query that calls a Web service method Q969131 KB969131 May 18, 2009
968449 FIX: A query that runs in parallel on a multiprocessor computer returns incorrect results in SQL Server 2005 or in SQL Server 2008 Q968449 KB968449 May 18, 2009
968290 FIX: A mining model of the Microsoft Decision Tree algorithm generates incorrect nodes when you set the MINIMUM_SUPPORT parameter to "9" in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services Q968290 KB968290 May 18, 2009
968080 FIX: An access violation occurs when you run the DBCC CLEANTABLE statement for a table that has a column of the bit data type in SQL Server 2008 Q968080 KB968080 May 18, 2009
967983 FIX: You receive an incorrect result when you enable the ANSI_NULLS database option and run a query against an indexed view in SQL Server 2005 or in SQL Server 2008 Q967983 KB967983 May 18, 2009
967337 FIX: When you run a stored procedure that contains a query that uses the FOR XML EXPLICIT clause, you may obtain a schema that is badly formed in SQL Server 2005 or in SQL Server 2008 Q967337 KB967337 May 18, 2009
967206 FIX: You obtain incorrect values for a column when you use the OPENROWSET function to import data from a data file by using an XML format file in SQL Server 2005 or in SQL Server 2008 Q967206 KB967206 May 18, 2009
961811 FIX: The CPU usage and the memory usage increase gradually and many session IDs are in the dormant status in SQL Server 2005 and in SQL Server 2008 Q961811 KB961811 May 18, 2009
961106 FIX: Error message when you run a query in SQL Server 2005 or in SQL Server 2008: "Internal Query Processor Error: The query processor could not produce a query plan" Q961106 KB961106 May 18, 2009
961049 FIX: When you run a query that uses the NOLOCK table hint in SQL Server 2005 or in SQL Server 2008 to retrieve BLOB data, the query runs very slowly Q961049 KB961049 May 18, 2009
968159 FIX: Error message when you run series of the CREATE SESSION CUBE statement and the DROP SESSION CUBE statement in Microsoft SQL Server 2008 Analysis Services: "An unexpected exception occurred" Q968159 KB968159 April 22, 2009
968152 FIX: Error message when you synchronize a database in Microsoft SQL Server 2008 Analysis Services: "Message: Errors in the metadata manager. An error occurred when loading the Analysis cube" Q968152 KB968152 April 22, 2009
967480 FIX: Error message when you try to view the properties of a database in SQL Server 2008 Management Studio: "Arithmetic overflow error converting expression to data type int" Q967480 KB967480 April 22, 2009
967178 FIX: When you restore a SQL Server 2005 backup file in SQL Server 2008, the operation takes much longer than when you restore the same backup file in SQL Server 2005 Q967178 KB967178 April 22, 2009
967162 FIX: The header of a SQL Server 2008 Reporting Services multiple-page report only appears on the first page if the report contains multiple row groups that do not have the Tablix row group area Q967162 KB967162 April 22, 2009
965221 FIX: When you run a query against multiple remote tables in SQL Server 2008, the query runs slowly Q965221 KB965221 April 22, 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 22, 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 22, 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 22, 2009
961526 FIX: When you view a SQL Server 2008 Reporting Services report in the Print Preview window, additional spaces are added to columns that use conditional visibility Q961526 KB961526 April 22, 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
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
967889 FIX: Performance issues occur when you perform some operations on a database that contains many extended properties in SQL Server 2008 Management Studio Q967889 KB967889 April 16, 2009
967821 FIX: Error message when you open a symmetric key that is encrypted by another symmetric key in SQL Server 2008: "The decryption key is incorrect" Q967821 KB967821 April 16, 2009
967148 FIX: An incorrect result is returned in SQL Server 2008 Analysis Services when you run multiple UPDATE CUBE statements in one transaction or update multiple measures in a single UPDATE CUBE statement in one transaction Q967148 KB967148 April 16, 2009
961803 FIX: Error message when you unbind a default for a column in a database that is restored from a SQL Server 2000 backup in SQL Server 2008: "Invalid object name ' '" Q961803 KB961803 April 16, 2009
962900 FIX: Error message when you run a query that involves an outer join operation in SQL Server 2008: "Attempting to set a non-NULL-able column's value to NULL" Q962900 KB962900 April 15, 2009
961633 FIX: A SQL Server 2008 Reporting Services report is displayed incorrectly in Mozilla Firefox if the report is displayed by using the ReportViewer control Q961633 KB961633 April 15, 2009
963070 FIX: You cannot edit or debug an SSIS package in BIDS when SQL Server 2008 Enterprise Edition, Standard Edition, Developer Edition, or Evaluation edition is installed without the SSIS feature Q963070 KB963070 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
968828 FIX: The system objects may not be checked as expected when you use different policy evaluation modes in SQL Server 2008 Q968828 KB968828 April 8, 2009
956031 FIX: Error message when you estimate the compression on a table in SQL Server 2008: "Subquery returned more than 1 value" Q956031 KB956031 April 8, 2009
955769 FIX: The Shared Memory protocol for an instance of SQL Server 2008 is always enabled and the VIA protocol for the instance is always disabled after you repair the instance Q955769 KB955769 April 8, 2009
968693 FIX: A query that uses parameters and the RECOMPILE option returns incorrect results when you run the query in multiple connections concurrently in SQL Server 2008 Q968693 KB968693 April 7, 2009
968599 FIX: Error message when you try to specify the SQL Server 2008 Reporting Services account as the credential for a report server in SharePoint Central Administration: "Unable to connect to Report Server WMI provider" Q968599 KB968599 April 7, 2009
968587 FIX: The aggregate value is incorrect when you design a query that contains some entity groups by using the Report Model Query Designer in SQL Server 2008 or in SQL Server 2005 Q968587 KB968587 April 7, 2009
963658 FIX: PAGE compression is removed from a SQL Server 2008 data table after you shrink the database Q963658 KB963658 April 7, 2009
960806 FIX: Error message when you try to activate an Excel 2007 embedded worksheet in a Word 2007 document after you install SQL Server 2008 Data Mining Add-ins for Office 2007: "The program used to create this object is Excel" Q960806 KB960806 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
968784 FIX: A key on an EKM provider is created successfully even if the provider does not support the algorithm that is used to create the key in SQL Server 2008 Q968784 KB968784 March 19, 2009
956150 FIX: An image that is nested in a Tablix cell in SQL Server 2008 Reporting Services is displayed incorrectly when the Sizing property of the image is set to AutoSize Q956150 KB956150 March 19, 2009
956138 FIX: You cannot upgrade a non-English instance of SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services Q956138 KB956138 March 19, 2009
955949 FIX: Cluster upgrade to SQL Server 2008 fails when SQL Server 2005 cluster nodes have different installed features Q955949 KB955949 March 19, 2009
955948 FIX: When you install a clustered instance of SQL Server 2008, account validation fails even though you have specified the correct domain account and password Q955948 KB955948 March 19, 2009
955943 FIX: The Processes pane in the Activity Monitor incorrectly shows sessions as head blockers in SQL Server 2008 Q955943 KB955943 March 19, 2009
967614 FIX: You may receive incorrect data when you run a query in which SQL Server uses an indexed view in the execution plan in SQL Server 2008 Q967614 KB967614 March 17, 2009
958599 FIX: The output from the DBCC MEMORYSTATUS command indicates that the Schema Manager cache uses more buffer space than expected in SQL Server 2008 Q958599 KB958599 January 20, 2009
961699 FIX: Error message when you perform a partition merge in SQL Server 2008 Analysis Services: "Detected inconsistency between User define slice and detected slice of partition" Q961699 KB961699 January 19, 2009
961481 FIX: A database audit specification is set to the sysrowsets object instead of the schema object that you specified in SQL Server Management Studio in SQL Server 2008 Q961481 KB961481 January 19, 2009
961393 FIX: When you print a report by using the SQL Server 2008 Reporting Services Client-Side Printing functionality, the spacing is too small or too large Q961393 KB961393 January 19, 2009
961360 FIX: The page numbers may be hardcoded in the pages after you export a report to Excel format in SQL Server 2008 Q961360 KB961360 January 19, 2009
961359 FIX: You receive an error message when you try to parse XML data in SQL Server 2008 Q961359 KB961359 January 19, 2009
961323 FIX: The memory usage increases gradually when you frequently back up or restore a database in SQL Server 2008 Q961323 KB961323 January 19, 2009
960996 FIX: When you use a ReportViewer control to view a SQL Server 2008 Reporting Services report that contains two pages, the formatting for the second page is lost Q960996 KB960996 January 19, 2009
960575 FIX: Some DML statements that should not be replicated are replicated to the subscribers when you replicate the execution of a stored procedure in a transactional replication in SQL Server 2005 or in SQL Server 2008 Q960575 KB960575 January 19, 2009
960574 FIX: Error message when you run the Snapshot Agent for a transactional replication that uses an Oracle 11g publisher in SQL Server 2005 or in SQL Server 2008: "Msg 21613, Level 16, State 1, Procedure sp_IHsyncmetadata, Line 223" Q960574 KB960574 January 19, 2009
960571 FIX: The Distribution Agent fails when you perform DML operations in a publication article and a concurrent snapshot is created in SQL Server 2005 or in SQL Server 2008 Q960571 KB960571 January 19, 2009
960562 FIX: Error message when you run two MDX queries on different connections at the same time in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services: "Transaction errors: The lock operation ended unsuccessfully because of deadlock" Q960562 KB960562 January 19, 2009
960283 FIX: You may encounter a deadlock scenario when you use table variables in SQL Server 2005 or in SQL Server 2008 Q960283 KB960283 January 19, 2009
959893 FIX: Some changes may not be replicated to the subscriber correctly in SQL Server 2005 or in SQL Server 2008 when the sum of the parameters exceeds 2,100 Q959893 KB959893 January 19, 2009
958947 FIX: When you run multiple full-text search queries in parallel in SQL Server 2008, the queries take much longer to finish than if you run them sequentially Q958947 KB958947 January 19, 2009
958940 FIX: The Disk I/O Usage chart and the Network Usage chart contain incorrect data when you view the Server Activity History report in SQL Server 2008 Q958940 KB958940 January 19, 2009
957357 FIX: You receive an error message that the file is being used by another process when you try to rename or move an output file from a job in SQL Server Agent in SQL Server 2005 Q957357 KB957357 December 20, 2008
956686 FIX: When you run a query that contains a JOIN operation in SQL Server 2005 or SQL Server 2008, and the ON clause of the JOIN operator contains a LIKE predicate, the query runs slower than in SQL Server 2000 Q956686 KB956686 December 20, 2008
956298 FIX: When you download the Report Builder ClickOnce application of SQL Server 2005 Reporting Services or SQL Server 2008 Reporting Services, the Reportbuilder.chm.deploy file is downloaded as the text/html content type instead of the application/octet-str Q956298 KB956298 December 20, 2008
956254 FIX: You may obtain an incorrect result when you use a cursor to perform DML operations on a table that does not have a clustered index in SQL Server 2008 or in SQL Server 2005 Q956254 KB956254 December 20, 2008
958555 FIX: A SQL Server Agent job that creates a ServerXMLHTTP object by using an ActiveX script remains in the Executing status and is never completed in SQL Server 2008 or in SQL Server 2005 Q958555 KB958555 December 19, 2008
956889 FIX: Error message when you run the snapshot agent on a replication of a stored procedure in SQL Server 2005 or in SQL Server 2008: "The Name property cannot have a value of @param＿name for this version of SQL Server" Q956889 KB956889 December 19, 2008
959376 FIX: Error message when you run the DBCC SHRINKFILE command or the DBCC SHRINKDATABASE command on a server that contains a SQL Server 2008 database: "5205 : DBCC SHRINKFILE: Moving Page <FileId>:<PageId> failed" Q959376 KB959376 December 16, 2008
959792 FIX: Some screens in the Cumulative Update 1 for Microsoft SQL Server 2008 setup contain incorrect information Q959792 KB959792 November 24, 2008
959785 FIX: Error message when you try to add articles to a publication that uses an Oracle Database 11g database as the publisher in SQL Server 2008: "Constraint column '<ColumnName>' not found in table '<TableName>'" Q959785 KB959785 November 24, 2008
958762 FIX: When you delete a maintenance plan in a restored SQL Server 2008 database, the maintenance plan is deleted on the server from which the database was originally backed up Q958762 KB958762 November 20, 2008
959889 FIX: When you try to install a failover instance on a computer that is running a 64-bit version of Windows, the x86 option is available on the options landing page in SQL Server 2008 Q959889 KB959889 November 18, 2008
959801 FIX: When you try to update SQL Server 2008 in attended mode, the update for SQL Support is not successful Q959801 KB959801 November 18, 2008
959800 FIX: The installation is not successful when you try to install BIDS in SQL Server 2008 Q959800 KB959800 November 18, 2008
959795 FIX: The License Terms screen of the Setup program for Cumulative Update 1 for SQL Server 2008 incorrectly states "To install Service Pack" Q959795 KB959795 November 18, 2008
959790 FIX: Database Engine Tuning Advisor in SQL Server 2008 does not recommend any index to analyze a query Q959790 KB959790 November 18, 2008
959789 FIX: You cannot upgrade from SQL Server 2008 Web to SQL Server 2008 Standard or to SQL Server 2008 Enterprise Q959789 KB959789 November 18, 2008
959788 FIX: Dr. Watson error information is not posted in the Problem Reports and Solutions window if SQL Server 2008 Setup fails Q959788 KB959788 November 18, 2008
959783 FIX: A deadlock occurs when you implement DDL statements against the partitions that are defined in a partitioned table in SQL Server 2008 Q959783 KB959783 November 18, 2008
959782 FIX: You cannot access Books Online help from the Activity Monitor feature in SQL Server 2008 by pressing the F1 Q959782 KB959782 November 18, 2008
959780 FIX: When an AMO object is used in the SQL Server 2008 CLR stored procedure to create or update Analysis Services objects, the stored procedure may fail Q959780 KB959780 November 18, 2008
959776 FIX: Visual Studio 2008 stops responding when you leave a SQL Server 2008 Analysis Services-based database project idle for some time Q959776 KB959776 November 18, 2008
959774 FIX: Calculated members in a SQL Server 2008 database are not evaluated, and the advanced filters return unexpected results when you run the Filter function in an Excel 2007 PivotTable report Q959774 KB959774 November 18, 2008
959773 FIX: When you try to use a subselect query that has calculated members in Excel 2007, the query returns an unexpected error Q959773 KB959773 November 18, 2008
959771 FIX: When Excel 2007 tries to connect to an OLAP cube on a server that is running SQL Server 2005, the connection fails Q959771 KB959771 November 18, 2008
959768 FIX: The results of a writeback operation to a measure group are not reflected in a linked measure group in SQL Server 2008 Q959768 KB959768 November 18, 2008
958943 FIX: The Database column or the Task State column may be blank for some processes in the Process chart of Activity Monitor on a server that is running SQL Server 2008 Q958943 KB958943 November 18, 2008
958942 FIX: Activity Monitor shows the high wait times when the FSAGENT wait type is enabled on a server that is running SQL Server 2008 Q958942 KB958942 November 18, 2008
958941 FIX: The database name or the database ID number does not appear in the "Most Expensive Queries" chart in the Activity Monitor when you run a query on a server running SQL Server 2008 Q958941 KB958941 November 18, 2008
958790 FIX: In SQL Server 2008, SQL Server Management Studio generates a CREATE TABLE script instead of creating a DROP TABLE script Q958790 KB958790 November 18, 2008
958759 FIX: SQL Server Management Studio uses the simple recovery model to create a new database when you click "New Database" in SQL Server 2008 Q958759 KB958759 November 18, 2008
958758 FIX: Full-text search functionality does not work in SQL Server 2008 Express Edition Q958758 KB958758 November 18, 2008
958757 FIX: You cannot use the SQL Server 2008 version of SMO to manage certificates in SQL Server 2005 and in SQL Server 2000 Q958757 KB958757 November 18, 2008
958496 FIX: You receive error code 18834 from the Log Reader Agent in SQL Server 2008 Q958496 KB958496 November 18, 2008
958479 FIX: Error message when you try to export a SQL Server 2008 Reporting Services report by using Report Manager: "Internet Explorer cannot download <ReportName>.xls from <URL>" Q958479 KB958479 November 18, 2008
957815 FIX: A SQL Server 2008 query returns incorrect results when you create a spatial index in a table that contains a composite primary key Q957815 KB957815 November 18, 2008
945127 FIX: You may still experience the performance issue that is described in KB article 940945 after you install Cumulative Update 3 for SQL Server 2005 Service Pack 2 or after you install SQL Server 2008 Q945127 KB945127 November 18, 2008
956036 FIX: Error message when you process a partition from SQL Server 2005 Analysis Services Cumulative Update 7 or from the release version of SQL Server 2008 Analysis Services: "Detected inconsistency between User define slice and detected slice of partition" Q956036 KB956036 October 28, 2008
958548 FIX: A query that performs multiple Clustered Index Seek operations or RID Lookup operations fails with an assertion in SQL Server 2005 Q958548 KB958548 October 20, 2008
957872 FIX: When you update rows by using a cursor in SQL Server 2008, the update may take a long time to finish Q957872 KB957872 October 15, 2008
957819 FIX: A SQL Server 2008 Analysis Services server may stop responding when you try to run an MDX query that uses cell security Q957819 KB957819 September 22, 2008
957817 FIX: You cannot expand the Facets node under the Policy Management node in SQL Server Management Studio in a non-English version of SQL Server 2008 Q957817 KB957817 September 19, 2008
957811 FIX: You receive an error message that states that the broker GUIDs do not match when you try to establish database mirroring in SQL Server 2008 or in SQL Server 2005 Q957811 KB957811 September 19, 2008
957809 FIX: Event ID 7904 is logged, and the SQL Server 2008 database is corrupted when you restore a SQL Server 2008 database from a sequence of transaction log backups Q957809 KB957809 September 19, 2008
957807 FIX: A new node is not added to a SQL Server 2008 Analysis Services cluster or a SQL Server 2008 Reporting Services cluster if the SQL Server 2008 Database Engine is not installed Q957807 KB957807 September 19, 2008
957806 FIX: The CompleteFailoverCluster action does not detect the correct SKU that is prepared by using the PrepareFailoverCluster action in SQL Server 2008 Q957806 KB957806 September 19, 2008
957461 FIX: Data collection may stop on a heavily loaded server that is running SQL Server 2008 Q957461 KB957461 September 19, 2008
957457 FIX: You cannot repair an instance of SQL Server 2008 from CD or DVD media if the original installation is from a network share or a local drive Q957457 KB957457 September 19, 2008
957456 FIX: After you use the PrepareFailoverCluster command to prepare a failover cluster instance, you cannot uninstall the prepared failover cluster instance in SQL Server 2008 Q957456 KB957456 September 19, 2008
957333 FIX: A SQL Server 2008 Reporting Services report may repaginate continually and consume 100% of CPU resources Q957333 KB957333 September 19, 2008
957332 FIX: Data disappears from a report that contains an inner group that is set to an initial state of "Hidden" in SQL Server 2008 Reporting Services Q957332 KB957332 September 19, 2008
957118 FIX: Images in rows are not displayed correctly for static Tablix members in a SQL Server 2008 Reporting Services report Q957118 KB957118 September 19, 2008
957111 FIX: You receive an error message when you use the LoadReportDefinition API to view a drillthrough report or a subreport report in Report Builder in SQL Server 2008 Reporting Services Q957111 KB957111 September 19, 2008
957107 FIX: A dump file may be generated in the Reporting Services Logfiles folder and you may receive an error message when you try to render a report in SQL Server 2008 Reporting Services Q957107 KB957107 September 19, 2008
956039 FIX: Error message when you run an MDX query that uses the CREATE GLOBAL CUBE statement to create a local cube in SQL Server 2008 Analysis Services or in SQL Server 2005 Analysis Services: "The syntax for '<MDXFunctionName>' is incorrect" Q956039 KB956039 September 19, 2008
955975 FIX: Error message when you update a table at the subscriber in a transactional replication in SQL Server 2008: "Updateable Subscriptions: Rows do not match between Publisher and Subscriber" Q955975 KB955975 September 19, 2008
955958 FIX: No rows are returned when you use the sp_replqueuemonitor stored procedure to list the queued messages for a queue-updating subscription in SQL Server Q955958 KB955958 September 19, 2008
955896 FIX: You cannot edit a component that has multiple inputs in a SQL Server 2008 or SQL Server 2005 Integration Services package Q955896 KB955896 September 19, 2008
955372 FIX: An incorrect aggregate value is returned when you run an MDX query against a parent/child dimension that has the HideMemberIf property set to ParentIsBlankSelfOrMissing in SQL Server 2008 or in SQL Server 2005 Q955372 KB955372 September 19, 2008
954831 FIX: In SQL Server 2008 or in SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session Q954831 KB954831 September 19, 2008
957805 FIX: When you try to run SQL Server 2008 database engine repair from a DVD, the repair fails, and you may receive error messages Q957805 KB957805 September 18, 2008
957375 FIX: A mirror server cannot fail over to a principal server in a SQL Server 2008 failover cluster Q957375 KB957375 September 18, 2008
957281 FIX: In SQL Server 2008, the IntelliSense feature may become unavailable when you type Transact-SQL statements in the Query Editor in SQL Server Management Studio Q957281 KB957281 September 18, 2008
957279 FIX: The IntelliSense feature stops working when you type a query that has a specific lexical combination in SQL Server Management Studio in SQL Server 2008 Q957279 KB957279 September 18, 2008
957277 FIX: The IntelliSense feature does not work correctly for a database that uses the Turkish collation and that uses the case-insensitive collation sort order in SQL Server 2008 Q957277 KB957277 September 18, 2008
957120 FIX: SQL Server 2008 Reporting Services interprets the Slant property as a positive slope Q957120 KB957120 September 18, 2008
957113 FIX: Error message when you try to create a query against a Hyperion Essbase cube database: "OLAP error (1260046): Unknown Member PARENT_UNIQUE_NAME used in query" Q957113 KB957113 September 18, 2008
957112 FIX: SQL Server 2008 Reporting Services may stop responding when you move a history snapshot or a linked report to a new folder location Q957112 KB957112 September 18, 2008
957108 FIX: The Gauge report item uses only one point after you add multiple points to the item in SQL Server 2008 Reporting Services Q957108 KB957108 September 18, 2008
957104 FIX: When you try to run a report that has a recursive hierarchy and that uses toggles in the hierarchy, you may receive unpredictable results in SQL Server 2008 Reporting Services Q957104 KB957104 September 18, 2008
957102 FIX: Error message when you try to run or preview a very large report in Microsoft SQL Server 2008 Reporting Services: "Exception of type System.OutOfMemoryException was thrown" Q957102 KB957102 September 18, 2008
956218 FIX: A NullReferenceException error for T-SQL Debugger occurs when you use the SET SHOWPLAN_XML ON option in a Transact-SQL statement on a instance of SQL Server 2008 Q956218 KB956218 September 18, 2008
957820 FIX: The mining model opens a blank task editor window when you try to deploy the Data Mining Model Training task in a SQL Server 2008 Integration Services project in Business Intelligence Development Studio Q957820 KB957820 September 17, 2008
957814 FIX: The result for the Sum or Count function returns an empty value when you query a SQL Server 2008 Analysis Services cube Q957814 KB957814 September 17, 2008
957810 FIX: In SQL Server 2008, a query returns incorrect results for the Date data type when you run the query on a partitioned table that uses data compression on only one of the partitions Q957810 KB957810 September 17, 2008
957278 FIX: The IntelliSense feature incorrectly completes the logical operators in the CASE WHEN clause in SQL Server 2008 Q957278 KB957278 September 17, 2008
957103 FIX: Error message when you try to view a report in SQL Server 2008 Reporting Services: "Object reference not set to an instance of an object. (rsRuntimeErrorInExpression)" Q957103 KB957103 September 17, 2008
957101 FIX: Some lists that use visibility toggles may not work as expected when you upgrade to SQL Server 2008 Reporting Services Q957101 KB957101 September 17, 2008
956216 FIX: The Transact-SQL debugger automatically saves changes to a script file when you run the script in debugging mode in SQL Server 2008 Management Studio Q956216 KB956216 August 21, 2008
955445 FIX: Access violations may occur after you enable a 64-bit version of SQL Server 2008 to use large code pages on Windows Server 2008 Q955445 KB955445 August 6, 2008

SQL Server 2008 articles, fixes and updates - letter F