February 2009 – Technical Rollup Mail – SQL Server
News
Technical RollUp
https://blogs.technet.com/trm/default.aspx
SQL Release Services
Cumulative Update #3 for SQL Server 2008 RTM
Documents
Best Practices for Semantic Data Modeling for Performance and Scalability
Analysis Services Distinct Count Optimization
Scale-Out Querying with Analysis Services
https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/scoqryas.mspx
Server Connectivity How-to Topics (Database Engine)
This section of SQL Server 2008 Books Online contains step-by-step instructions that show how to configure Microsoft SQL Server to accept connections from network clients.
https://technet.microsoft.com/library/ms190608.aspx
Database Engine Connectivity How-to Topics
Configuring connectivity to instances of the Microsoft SQL Server Database Engine includes configuration tasks on both the server and the client computers. In many cases the both computers must be configured to use the same options, such as a common network protocol. Learn more by reviewing topics in this section of SQL Server 2008 Books Online.
https://technet.microsoft.com/library/ms180771.aspx
Connectivity Options for Microsoft SQL Server 2008 Integration Services
This white paper provides an overview of the connectivity options that are available for SQL Server 2008 Integration Services.
https://technet.microsoft.com/library/dd299429.aspx
Downloads
SQL Server 2008 System Views Map
The Microsoft SQL Server 2008 System Views Map shows the key system views included in SQL Server 2008, and the relationships between them.
SQL Data Services (SDS) SDK (CTP)
This community technology preview (CTP) release of the Software Development Kit for SDS includes tools and client side components useful to developers building applications with SDS.
SQL Server JDBC Driver 2.0 CTP (January 2008)
Download the SQL Server JDBC Driver 2.0 CTP, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5.
Web Platform Installer 1.0
The Microsoft Web Platform Installer is a free tool that makes it simple to download and install the latest components of the Microsoft Web Platform, including the IIS, SQL Server Express, .NET Framework and Visual Web Developer.
Microsoft SQL Server 2005 SP3 Readme
Before you install Microsoft SQL Server 2005 Service Pack 3 (SP3), download, extract, and read the SP3 Setup documentation, and review the SP3 Readme files.
Improving Microsoft Dynamics CRM Performance and Securing Data with Microsoft SQL Server 2008
This paper provides an overview, benchmark results, and recommendations for implementing selected Microsoft SQL Server 2008 features that can improve the performance of Microsoft Dynamics CRM 4.0 and secure the CRM database.
Using Analysis Services with the Project Server 2007 Cube Building Service
Walks through the process of creating an Analysis Services repository, and then describes the configuration steps necessary for the Project Server 2007 computer and client computers in order to get the Cube Building Service working properly.
SQL Server Data Mining Add-ins for Office 2007
Download SQL Server 2005 Data Mining Add-ins for Office 2007. This package includes two add-ins for Microsoft Office Excel 2007 (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2007 (Data Mining Templates).
Microsoft SQL Server Protocol Documentation
The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and used in Microsoft SQL Server 2008.
System Center Operations Manager 2007 SP1 Documentation
This download contains documentation for System Center Operations Manager 2007 SP1.
Microsoft Dynamics AX 2009 White Paper: Configuring Kerberos Authentication with Role Centers
How to configure Kerberos authentication for Microsoft SQL Server reporting with Enterprise Portal Role Center pages.
Microsoft Dynamics AX 2009 White Paper: Configuring Enterprise Portal and Role Centers with SQL Reporting
Checklists and information to help administrators set up and configure Microsoft Dynamics AX 2009 Enterprise Portal and Role Centers with Microsoft SQL Server reporting.
Events/Webcasts
SQL Server 2008 Hands-On Lab
Learn about the new features in SQL Server 2008 in this one day hands-on lab. Topics include: Resource Governor, Transparent Data Encryption, New Spatial Capabilities, Analysis Services, Managing the Reporting Services Infrastructure
New KB's
SQL 2000
SQL Svr Standard Edtn 2000 EN: FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers (Updated)
https://support.microsoft.com/kb/304850/EN-US
SQL 2005
SQL Svr 2005 Analysis Svcs EN: FIX: Error message when you connect to an instance of SQL Server 2008 Analysis Services by using the AMO library that is included with SQL Server 2005 Service Pack 2 Analysis Services: "Cannot connect to Analysis Services version '10.0.1600.22'" (Updated)
https://support.microsoft.com/kb/936081/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services after you install cumulative update 7 for SQL Server 2005 Service Pack 2: "The SQL Server Analysis Services (<InstanceName>) service terminated unexpectedly" (Updated)
https://support.microsoft.com/kb/955374/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: MDX queries that use the EXCEPT function in the WHERE clause run much slower after you install a hotfix or a cumulative update whose version is later than the version of Cumulative Update 4 for SQL Server 2005 SP2 (Updated)
https://support.microsoft.com/kb/958500/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: You may be unable to cancel an MDX query that uses the NonEmpty function on a large set in SQL Server 2005 Analysis Services (Updated)
https://support.microsoft.com/kb/958549/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: Error message when you run a DB2 query that uses the WITH UR query hint in SQL Server 2005 Analysis Services: "OLE DB error: OLE DB or ODBC error: An unexpected token "WITH" was found following "<Query>""
https://support.microsoft.com/kb/959026/EN-US
SQL Svr 2005 Analysis Svcs EN: 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" (Updated)
https://support.microsoft.com/kb/960562/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: An incorrect result is returned when you run a Multidimensional Expressions (MDX) query in Microsoft SQL Server 2005 Analysis Services
https://support.microsoft.com/kb/960611/EN-US
SQL Svr 2005 Reporting Svcs EN: FIX: When you export a SQL Server 2005 Reporting Services report that contains an image to a .pdf format file, the .pdf file is displayed incorrectly
https://support.microsoft.com/kb/953941/EN-US
SQL Svr 2005 Reporting Svcs EN: Best practices for changing the service account for the report server in SQL Server 2005 Reporting Services
https://support.microsoft.com/kb/958999/EN-US
SQL Svr 2005 Reporting Svcs EN: FIX: Error message when you view a SQL Server Reporting Services report in the ReportViewer control in Visual Studio 2008: "Object reference not set to an instance of an object"
https://support.microsoft.com/kb/959595/EN-US
SQL Svr Enterprise Edtn 2005 EN: How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console (Updated)
https://support.microsoft.com/kb/316898/EN-US
SQL Svr Enterprise Edtn 2005 EN: How to identify your SQL Server version and edition (Updated)
https://support.microsoft.com/kb/321185/EN-US
SQL Svr Enterprise Edtn 2005 EN: Description of TCP/IP settings that you may have to adjust when SQL Server connection pooling is disabled (Updated)
https://support.microsoft.com/kb/328476/EN-US
SQL Svr Enterprise Edtn 2005 EN: FIX: Log Reader Agent fails with error code 18834 in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/958684/EN-US
SQL Svr Standard Edtn 2005 EN: Changes to the readme file for SQL Server 2005 (Updated)
https://support.microsoft.com/kb/907284/EN-US
SQL Svr Standard Edtn 2005 EN: How to obtain the latest service pack for SQL Server 2005 (Updated)
https://support.microsoft.com/kb/913089/EN-US
SQL Svr Standard Edtn 2005 EN: Error message when you try to install a SQL Server 2005 service pack or a SQL Server 2005 hotfix package: "Error 29528. The setup has encountered an unexpected error while Setting Internal Properties" (Updated)
https://support.microsoft.com/kb/925976/EN-US
SQL Svr Standard Edtn 2005 EN: SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies (Updated)
https://support.microsoft.com/kb/931279/EN-US
SQL Svr Standard Edtn 2005 EN: The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released (Updated)
https://support.microsoft.com/kb/937137/EN-US
SQL Svr Standard Edtn 2005 EN: Cumulative update package 3 for SQL Server 2005 Service Pack 2 (Updated)
https://support.microsoft.com/kb/939537/EN-US
SQL Svr Standard Edtn 2005 EN: Cumulative update package 5 for SQL Server 2005 Service Pack 2 (Updated)
https://support.microsoft.com/kb/943656/EN-US
SQL Svr Standard Edtn 2005 EN: Description of the Replay Markup Language (RML) Utilities for SQL Server (Updated)
https://support.microsoft.com/kb/944837/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The full-text search engine stops responding intermittently, the CPU utilization is high, and all full-text queries are blocked when you use full-text search in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/945996/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run a full-text search query in SQL Server 2005: "Insufficient system resources exist to complete the requested service" (Updated)
https://support.microsoft.com/kb/948452/EN-US
SQL Svr Standard Edtn 2005 EN: On a computer that has a multicore processor, if the ratio of the logical processors to the physical sockets is not divisible by two, you cannot install SQL Server 2005 (Updated)
https://support.microsoft.com/kb/954835/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you try to install SQL Server 2005: "[Microsoft][SQL Native Client][SQL Server]The certificate cannot be dropped because one or more entities are either signed or encrypted using it" (Updated)
https://support.microsoft.com/kb/955920/EN-US
SQL Svr Standard Edtn 2005 EN: 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 (Updated)
https://support.microsoft.com/kb/956254/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: When you run a query that contains a JOIN operation in SQL Server 2005, and the ON clause of the JOIN operator contains a LIKE predicate, the query runs slower than in SQL Server 2000 (Updated)
https://support.microsoft.com/kb/956686/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A time-out setting is not available for the Web Service task in a Microsoft SQL Server 2005 Integration Services (SSIS) package (Updated)
https://support.microsoft.com/kb/956911/EN-US
SQL Svr Standard Edtn 2005 EN: 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 (Updated)
https://support.microsoft.com/kb/957357/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The file growth setting is incorrect after you restore a database from SQL Server 2000 in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/958004/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The size of the SQL Server 2005 error log file or of the SQL Server 2008 error log file grows very quickly when query notifications are created and destroyed in a high ratio (Updated)
https://support.microsoft.com/kb/958006/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The values of the datetime column are not same for the rows that are copied when you copy data to a table by using the GETDATE() function in Microsoft SQL Server 2005 (Updated)
https://support.microsoft.com/kb/958547/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you restore a transaction log for a database by using the STANDBY option in SQL Server 2005: "The transaction log for database '<DatabaseName>' is full" (Updated)
https://support.microsoft.com/kb/958554/EN-US
SQL Svr Standard Edtn 2005 EN: 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 (Updated)
https://support.microsoft.com/kb/958555/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A memory leak occurs when you repeatedly invoke a trigger that contains the RAISERROR statement by using a SQLCLR stored procedure in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/958573/EN-US
SQL Svr Standard Edtn 2005 EN: Cumulative update package 11 for SQL Server 2005 Service Pack 2 (Updated)
https://support.microsoft.com/kb/958735/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: When you validate a publication in a transactional replication, articles that you added after you added a vertical filter to an article are not validated in SQL Server 2005
https://support.microsoft.com/kb/959000/EN-US
SQL Svr Standard Edtn 2005 EN: 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
https://support.microsoft.com/kb/959001/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Only the first command in a transaction is replicated to the subscriber when you set the MaxCmdsInTran parameter of Log Reader Agent to 1 in SQL Server 2005
https://support.microsoft.com/kb/959003/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: When a process that is running on an instance of SQL Server 2005 consumes a large amount of memory, dump files are generated in the folder that contains the SQL Server error log
https://support.microsoft.com/kb/959004/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Database mirroring sessions may stop intermittently in SQL Server 2005
https://support.microsoft.com/kb/959006/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you use SQL Server Service Broker in SQL Server 2005: "Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 589824"
https://support.microsoft.com/kb/959007/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you start database mirroring in SQL Server 2005 on a database that is restored or upgraded from SQL Server 2000: "The Service Broker ID for the remote copy of database "<DatabaseName>" does not match the ID on the principal server"
https://support.microsoft.com/kb/959008/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Target endpoints in Service Broker of SQL Server 2005 leak in the valid message exchange pattern where the target sends only the end conversation message
https://support.microsoft.com/kb/959009/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when an application that uses Service Broker sends messages in SQL Server 2005: "The conversation endpoint is not in a valid state for SEND"
https://support.microsoft.com/kb/959010/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: When you shrink a database that has the SNAPSHOT transaction isolation level enabled in SQL Server 2005, the shrink operation is not completed successfully (Updated)
https://support.microsoft.com/kb/959012/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The synchronization process is slow, and the CPU usage is high on the computer that is configured as the Distributor in SQL Server 2005
https://support.microsoft.com/kb/959013/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A conflict with the foreign key constraint occurs when you update the case of the column values in the primary key table or you pad column values in the primary key table in SQL Server 2005
https://support.microsoft.com/kb/959015/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Rows that include a NULL column may not be deleted when you delete rows from a table by using "<ImageColumnName> is NULL" as the condition in the WHERE clause in SQL Server 2005
https://support.microsoft.com/kb/959016/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You receive an incorrect result when you query a column of the varchar(max) data type that contains only one character from a table in SQL Server 2005
https://support.microsoft.com/kb/959017/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You receive an incorrect result when you run a query that uses the LIKE operator in SQL Server 2005
https://support.microsoft.com/kb/959019/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: When you use a CASE function that returns constants of the binary data type, some constants are trimmed incorrectly even after you run the SET ANSI_PADDING ON statement in SQL Server 2005
https://support.microsoft.com/kb/959020/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A blocking issue occurs when you run the Merge Agent in SQL Server 2005
https://support.microsoft.com/kb/959023/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: When the Merge Agent synchronizes multiple batches of changes, the synchronization may take a long time to finish or the synchronization may expire unexpectedly in SQL Server 2005
https://support.microsoft.com/kb/959024/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you parse a query after you run the SET XACT_ABORT ON statement in SQL Server 2005: ".Net SqlClient Data Provider: A severe error occurred on the current command" (Updated)
https://support.microsoft.com/kb/959028/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: If you enter many rows into the Fuzzy Grouping transformation, you may obtain an incorrect result in SQL Server 2005 Integration Services (Updated)
https://support.microsoft.com/kb/959030/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you try to expand the Catalogs node for a linked server that links to a Teradata Database in SQL Server 2005: "Cannot obtain the schema rowset DBSCHEMA_CATALOGS for OLE DB provider SQL Server for linked server (null)" (Updated)
https://support.microsoft.com/kb/959031/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A peer-to-peer transactional replication does not replicate rows if you rebuild the index for a published table at the same time as you insert data in the published table in SQL Server 2005 or in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/959032/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you install Cumulative Update 10 or Cumulative Update 9 for SQL Server 2005 Service Pack 2 on a drive that uses the FAT32 file system: "Unexpected Error Occurred" (Updated)
https://support.microsoft.com/kb/959132/EN-US
SQL Svr Standard Edtn 2005 EN: Cumulative update package 1 for SQL Server 2005 Service Pack 3 (Updated)
https://support.microsoft.com/kb/959195/EN-US
SQL Svr Standard Edtn 2005 EN: How to customize the quota for the TokenAndPermUserStore cache store in SQL Server 2005 Service Pack 3
https://support.microsoft.com/kb/959823/EN-US
SQL Svr Standard Edtn 2005 EN: 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 (Updated)
https://support.microsoft.com/kb/959893/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A significant delay occurs after you cancel a query on a client computer that connects to SQL Server 2005 across a slow link (Updated)
https://support.microsoft.com/kb/960110/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The changes to the data source of a SQL Server 2005 Integration Services package may be lost when the package is run by a job (Updated)
https://support.microsoft.com/kb/960161/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You may encounter a deadlock scenario when you use table variables in SQL Server 2005 or in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/960283/EN-US
SQL Svr Standard Edtn 2005 EN: Error message when you install SQL Server 2005 Service Pack 3 on Windows Vista or Windows Server 2008: "Visual Studio 2005 has a known compatibility issue with this version of Windows" (Updated)
https://support.microsoft.com/kb/960320/EN-US
SQL Svr Standard Edtn 2005 EN: 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 (Updated)
https://support.microsoft.com/kb/960542/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you create a WMI event alert by using the sp_add_alert stored procedure in a SQL Server 2005 cluster: "The @wmi_query could not be executed in the @wmi_namespace provided" (Updated)
https://support.microsoft.com/kb/960552/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run a query that selects a column of the xml data type in SQL Server 2005: "'?', hexadecimal value 0xDC55, is an invalid character" (Updated)
https://support.microsoft.com/kb/960555/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you try to shrink a database in SQL Server 2005 Service Pack 2: "File ID <FileID> of database ID <DatabaseID> cannot be shrunk as it is either being shrunk by another process or is empty" (Updated)
https://support.microsoft.com/kb/960567/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A maintenance plan that contains a Rebuild Index task takes much longer to run in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/960570/EN-US
SQL Svr Standard Edtn 2005 EN: 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 (Updated)
https://support.microsoft.com/kb/960571/EN-US
SQL Svr Standard Edtn 2005 EN: 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" (Updated)
https://support.microsoft.com/kb/960574/EN-US
SQL Svr Standard Edtn 2005 EN: 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 (Updated)
https://support.microsoft.com/kb/960575/EN-US
SQL Svr Standard Edtn 2005 EN: The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released (Updated)
https://support.microsoft.com/kb/960598/EN-US
SQL Svr Standard Edtn 2005 EN: Mere Query timeout can lead to fullscale SQLCLR AppDomain unload in some conditions.
https://support.microsoft.com/kb/960922/EN-US
SQL Svr Standard Edtn 2005 EN: Error message when you try to create a full-text index in SQL Server 2005: "Full-text crawl manager has not been initialized. Any crawl started before the crawl manager was fully initialized will need to be restarted"
https://support.microsoft.com/kb/961662/EN-US
SQL Svr Standard Edtn 2005 EN: In SQL Server 2005 or 2008, the DTS designer application cannot be started on a Windows Vista-based computer or on a Windows Server 2008-based computer
https://support.microsoft.com/kb/962874/EN-US
SQL Svr Std Edtn 2005 64Bit EN: FIX: The x64 version of SQL Server 2005 or of SQL Server 2008 may stop responding when you are performing a backup (Updated)
https://support.microsoft.com/kb/960543/EN-US
SQL 2008
SQL Svr Enterprise 2008 EN: How to update SQL Server 2008 Setup by running a newer version of the SQL Server 2008 Setup support files (Updated)
https://support.microsoft.com/kb/955392/EN-US
SQL Svr Enterprise 2008 EN: An access violation error message is logged in the SQL Server error log after you upgrade to SQL Server 2008: "Access Violation occurred reading address 00000000"
https://support.microsoft.com/kb/955831/EN-US
SQL Svr Enterprise 2008 EN: You receive a warning about the network binding order on the Setup Support Rules page when you install SQL Server 2008 in a failover cluster
https://support.microsoft.com/kb/955963/EN-US
SQL Svr Enterprise 2008 EN: The SQL Server 2008 builds that were released after SQL Server 2008 was released (Updated)
https://support.microsoft.com/kb/956909/EN-US
SQL Svr Enterprise 2008 EN: Where you can find more information about the SQL Server 2008 builds that were released after SQL Server 2008 and about the SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 and after SQL Server 2005 Service Pack 2 (Updated)
https://support.microsoft.com/kb/957826/EN-US
SQL Svr Enterprise 2008 EN: How to apply a SQL Server 2008 update to a failover cluster instance (Updated)
https://support.microsoft.com/kb/958734/EN-US
SQL Svr Enterprise 2008 EN: 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" (Updated)
https://support.microsoft.com/kb/959376/EN-US
SQL Svr Enterprise 2008 EN: Error message when you start the SQL Server 2008 Reporting Services Configuration Manager: "Invalid namespace"
https://support.microsoft.com/kb/960374/EN-US
SQL Svr Enterprise 2008 EN: Error message when you run the DBCC CHECKDB command on a computer that contains a SQL Server database: "Error 8967"
https://support.microsoft.com/kb/960791/EN-US
SQL Svr Standard 2008 EN: 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 (Updated)
https://support.microsoft.com/kb/956298/EN-US
SQL Svr Standard 2008 EN: You cannot add a cluster node when you install SQL Server 2008 Analysis Services and you do not install the SQL Server 2008 Database Engine (Updated)
https://support.microsoft.com/kb/956427/EN-US
SQL Svr Standard 2008 EN: 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" (Updated)
https://support.microsoft.com/kb/956889/EN-US
SQL Svr Standard 2008 EN: FIX: The output from the DBCC MEMORYSTATUS command indicates that the Schema Manager cache uses more buffer space than expected in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/958599/EN-US
SQL Svr Standard 2008 EN: 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
https://support.microsoft.com/kb/958760/EN-US
SQL Svr Standard 2008 EN: 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
https://support.microsoft.com/kb/958940/EN-US
SQL Svr Standard 2008 EN: 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
https://support.microsoft.com/kb/958947/EN-US
SQL Svr Standard 2008 EN: Cumulative update package 3 for SQL Server 2008
https://support.microsoft.com/kb/960484/EN-US
SQL Svr Standard 2008 EN: 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
https://support.microsoft.com/kb/960566/EN-US
SQL Svr Standard 2008 EN: 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"
https://support.microsoft.com/kb/960573/EN-US
SQL Svr Standard 2008 EN: FIX: You receive error 605 and error 824 when you run a query that inserts data into a temporary table in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/960770/EN-US
SQL Svr Standard 2008 EN: 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
https://support.microsoft.com/kb/960771/EN-US
SQL Svr Standard 2008 EN: Error message when you try to upgrade to SQL Server 2008: "Wait on the Database Engine recovery handle failed"
https://support.microsoft.com/kb/960781/EN-US
SQL Svr Standard 2008 EN: 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"
https://support.microsoft.com/kb/960864/EN-US
SQL Svr Standard 2008 EN: 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
https://support.microsoft.com/kb/960996/EN-US
SQL Svr Standard 2008 EN: 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"
https://support.microsoft.com/kb/961094/EN-US
SQL Svr Standard 2008 EN: 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"
https://support.microsoft.com/kb/961126/EN-US
SQL Svr Standard 2008 EN: FIX: In a SQL Server 2008 Reporting Services report that contains several levels, some items disappear when you collapse another item
https://support.microsoft.com/kb/961271/EN-US
SQL Svr Standard 2008 EN: FIX: A maintenance plan that contains a Rebuild Index task takes much longer than you expect to run in SQL Server 2008
https://support.microsoft.com/kb/961272/EN-US
SQL Svr Standard 2008 EN: 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"
https://support.microsoft.com/kb/961282/EN-US
SQL Svr Standard 2008 EN: FIX: An access violation may occur when you run a query that uses a parallel execution plan in SQL Server 2008
https://support.microsoft.com/kb/961283/EN-US
SQL Svr Standard 2008 EN: SQL Server service may not start after patch installed
https://support.microsoft.com/kb/961301/EN-US
SQL Svr Standard 2008 EN: FIX: The memory usage increases gradually when you frequently back up or restore a database in SQL Server 2008
https://support.microsoft.com/kb/961323/EN-US
SQL Svr Standard 2008 EN: FIX: You receive an error message when you try to parse XML data in SQL Server 2008
https://support.microsoft.com/kb/961359/EN-US
SQL Svr Standard 2008 EN: FIX: The page numbers may be hardcoded in the pages after you export a report to Excel format in SQL Server 2008
https://support.microsoft.com/kb/961360/EN-US
SQL Svr Standard 2008 EN: 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
https://support.microsoft.com/kb/961393/EN-US
SQL Svr Standard 2008 EN: 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
https://support.microsoft.com/kb/961481/EN-US
SQL Svr Standard 2008 EN: You receive a “Class not registered” error after you install SQL Server Management Studio 2008 on a computer running SQL Server Management Studio 2005
https://support.microsoft.com/kb/961638/EN-US
SQL Svr Standard 2008 EN: 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"