kbupdate.info ›
Daily Updated!
SQL Server 2008 articles, fixes and updates - Year 2008
Daily Updated!
chronological list: 2023 | ... 2009/12 11 10 9 8 7 6 5 4 3 1 | 2008 | 2005 | 2004 | 2003
alphabetical list: A B C D E F G H I K L M N O P Q R S T U V W X Y
This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2008 that have been released in Year 2008. The list is daily updated.
- 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
- 960781 Error message when you try to upgrade to SQL Server 2008: "Wait on the Database Engine recovery handle failed" Q960781 KB960781 December 9, 2008
- 960126 Error message when you upgrade from MSDE 2000 to SQL Server 2008 Express: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible." Q960126 KB960126 November 26, 2008
- 960124 In a localized Microsoft Windows operating system, the English version of the context-sensitive Help for SQL Server 2008 Report Builder is displayed instead of the localized context-sensitive Help Q960124 KB960124 November 26, 2008
- 960127 Error message when you install the 64-bit version of SQL Server 2008 Business Intelligence Development Studio: "Upgrade Failed due to the following Error. The error code is: -2147467259.Message:Unspecified error" Q960127 KB960127 November 25, 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
- 959375 How to change the Default Web Site port on a Team Foundation Server 2008 Application Tier Machine Q959375 KB959375 October 28, 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
- 955722 The cluster setup fails without a clear error message when you install a SQL Server 2008 failover cluster and you select a drive that does not have a drive letter assigned Q955722 KB955722 October 21, 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
- 958899 Setup log message makes user think setup is trying to install .Net 3.5 and incorrectly reports failure during locating media for .Net 3.5 Q958899 KB958899 October 16, 2008
- 958892 SQL Express default instance causes failure if Express is already installed Q958892 KB958892 October 16, 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
- 955782 Error message when you upgrade to SQL Server 2008: "API call rejected - No actions in Context" Q955782 KB955782 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
- 955406 The results of rule checks may be logged incorrectly when you try to install or upgrade to SQL Server 2008 Q955406 KB955406 September 16, 2008
- 955390 Message when you try to install SQL Server 2008 on a Windows Server 2003-based computer: "Access Denied" Q955390 KB955390 September 12, 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
- 955510 Reporting Services Configuration Manager for SQL Server 2008 Reporting Services does not start when both SQL Server 2005 and SQL Server 2008 are installed on a computer Q955510 KB955510 August 19, 2008
- 956208 Description of cross-version compatibility scenarios for merge replication in SQL Server Compact 3.5 Q956208 KB956208 August 12, 2008
- 956154 Activity Monitor or Performance Monitor may stop responding (hang) after you upgrade SQL Server Reporting Services 2008 CTP6 to SQL Server Reporting Services 2008 RTM Q956154 KB956154 August 11, 2008
- 955799 Error message when you use merge replication to replicate spatial data types from SQL Server 2008 to SQL Server 2008 Compact Edition Q955799 KB955799 August 11, 2008
- 955797 You can download SQL Server 2008 product samples from the SQL Server Community & Samples project hosting Web site Q955797 KB955797 August 11, 2008
- 956206 Error message when you try to create a new shared data source in SQL Server 2008 Reporting Services: "Specify a valid name" Q956206 KB956206 August 7, 2008
- 952218 Error message when you try to connect to SQL Server Compact 3.5 Service Pack 1 from SQL Server Management Studio in SQL Server 2008: "Unable to load Microsoft SQL Server Compact" Q952218 KB952218 August 7, 2008
- 956217 Transact-SQL Debugger is not restored to its previous state when the computer resumes from suspended mode in a SQL Server 2008 instance Q956217 KB956217 August 6, 2008
- 955717 SQL Server 2008 performance decreases when you use a dataflow task that involves a fast load Q955717 KB955717 August 6, 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
- 955801 Events 7009 and 7000 are logged, and you receive an error message after you uninstall SQL Native Client from a server that is running SQL Server 2008: "The request failed or the service did not respond in a timely fashion" Q955801 KB955801 July 31, 2008
- 955861 When you use the "sp_configure" Transact-SQL command to enable the FILESTREAM option in SQL Server 2008 or in SQL Server 2008 R2, an incorrect message is written to the SQL Server error log Q955861 KB955861 July 29, 2008
- 955628 SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages Q955628 KB955628 July 29, 2008