May 2009 - Technical Rollup Mail - SQL

News

Technical RollUp

https://blogs.technet.com/trm/default.aspx

Documents

SQL Server 2008 Service Pack 1 Now Available

https://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19

Service Pack 1 (SP1) focuses on essential updates only, primarily roll-ups of cumulative updates 1 to 3 and fixes to issues reported through the SQL Server community. SP1 eases deployment and management of Service Packs by introducing Slipstream, Service Pack Uninstall, and Report Builder 2.0 Click Once capability.

SQL Server 2008 Sustainability

https://download.microsoft.com/download/C/F/B/CFB498D0-37B0-4805-9B41-EE2FCA3F1196/SQL%20Sustainability%20Technical%20White%20Paper.doc

Microsoft IT produced the SQL Utility to improve SQL Server manageability through host consolidation, virtualization, and standardization.

Running SQL Server 2008 on Windows Server 2008

https://download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/SQL2008onWinSvr2008.docx

The combination of SQL Server 2008 and Windows Server 2008 offers enterprise IT administrators and professional developers a superlative platform for mission-critical applications together with enhanced end-to-end security, management, and development capabilities.

Troubleshooting Performance Problems in SQL Server 2008 Whitepaper

https://msdn.microsoft.com/en-us/library/dd672789.aspx

This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools such as:
? SQL Server Profiler
? System Monitor (in the Windows Server 2003 operating system) or
? Performance Monitor (in the Windows Vista operating system and Windows Server 2008), also known as Perfmon
? Dynamic management views (sometimes referred to as DMVs)
? SQL Server Extended Events (Extended Events) and the data collector, which are new in SQL Server 2008.

Server Consolidation with SQL Server 2008

https://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008Consolidation.docx

This 10-page paper discusses SQL Server 2008 flexibility, manageability, and scalability and performance.

Tuning the Performance of Change Data Capture in SQL Server 2008

https://msdn.microsoft.com/en-us/library/dd266396.aspx

Accessing External Data Sources with Analysis Services 2005

https://msdn.microsoft.com/en-us/library/aa964120(SQL.90).aspx

Accessing SQL Server Databases with PHP

https://msdn.microsoft.com/en-us/library/cc793139(SQL.90).aspx

Downloads

Server SQL Server Integration Services Starter Kit for Planning Server

Step-by-step directions detailing the recommended data import package steps in a typical PerformancePoint Planning Server application

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=05e2b2c7-3dbd-4b91-a9b1-7aa6cb876635

FRx 6.7 SP10 - Epicor Enterprise

Microsoft FRx works with a variety of general ledgers—including Microsoft Dynamics products—to help you get specific reports to decision-makers who need them, when they need them. Its financial analysis capabilities can help boost business intelligence across your company.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=eda7b1e5-b43f-45e7-bbb8-00e8ddf36505

FRx 6.7 SP10 - Sage MAS 200 for SQL

Microsoft FRx works with a variety of general ledgers—including Microsoft Dynamics products—to help you get specific reports to decision-makers who need them, when they need them. Its financial analysis capabilities can help boost business intelligence across your company.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=9f90b63f-8e72-4430-8c8f-1f6c91181078

SQL Server MP for OpsMgr 2007

The Microsoft SQL Server Management Pack for Operations Manager 2007 provides discovery and monitoring of SQL Server 2000, 2005 and 2008.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=8c0f970e-c653-4c15-9e51-6a6cadfca363

SQL Server 2005 Report Packs

These free report packs will simplify your report tasks, improve your business visibility and speed your decision making.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=d81722ce-408c-4fb6-a429-2a7ecd62f674

SQL Server JDBC Driver 2.0

Download the SQL Server JDBC Driver 2.0, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=99b21b65-e98f-4a61-b811-19912601fdc9

SQL Server 2008 Report Builder 2.0

Microsoft SQL Server 2008 Report Builder 2.0 provides an intuitive report authoring environment for business and power users. It supports the full capabilities of SQL Server 2008 Reporting Services. The download provides a stand-alone installer for Report Builder 2.0

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=dbddc9b6-6e19-4d4b-9309-13f62901b0d5

SQL Server Data Mining Add-ins for Office 2007

Download SQL Server 2008 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).

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=af070f2c-46f4-47b6-b7bf-48979b999aeb

Microsoft SQL Server 2008 Express Edition SP1

SQL Server 2008 Express is a free edition of SQL Server that is ideal for learning and building desktop and small server applications, and for redistribution by ISVs.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=01af61e6-2f63-4291-bcad-fd500f6027ff

Microsoft SQL Server 2008 Upgrade Advisor

Download the Microsoft SQL Server 2008 Upgrade Advisor. Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 to help you prepare for upgrades to SQL Server 2008.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=802d0632-5de7-4efd-ae43-ebe3fc078886

SQL Server 2008 SP1

Download SQL Server 2008 SP1.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19

Microsoft SQL Server 2008 Feature Pack, April 2009

Download the Microsoft SQL Server 2008 Feature Pack, a collection of stand-alone install packages that provide additional value for SQL Server 2008.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=b33d2c78-1059-4ce2-b80d-2343c099bcb4

SQL Server Reporting Services Add-in for SharePoint Technologies

The Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=58edd0e4-255b-4361-bd1e-e530d5aab78f

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.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=91ef5106-944a-41e1-b3a0-5bd3f2356f32

Azure Services Training Kit

Azure Services Training Kit

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=413e88f8-5966-4a83-b309-53b7b77edf78

SQL Server 2008 Express Edition SP1 CTP

Download the CTP of SQL Server 2008 Express Edition SP1.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=0f8df01e-b05b-401b-87e7-bc516683cfe0

SQL Server 2008 SP1 CTP

Download the CTP of SQL Server 2008 SP1.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=6f26fc45-f0ca-49cf-a6ee-840c7e8bb8af

Web PI 2.0 Beta

The Web Platform Installer (WebPI) is a simplified download/install experience for all of Microsoft’s free web products.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=d87a71e4-00bd-4204-8f25-f245feb0c3ad

Infrastructure Planning and Design

The Infrastructure Planning and Design (IPD) guides are the next version of Windows Server System Reference Architecture. The guides in this series help clarify and streamline design processes for Microsoft infrastructure technologies, with each guide addressing a unique infrastructure technology or scenario.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=ad3921fb-8224-4681-9064-075fdf042b0c

Microsoft® Visual Studio Team System 2008 Database Edition GDR R2

Microsoft® Visual Studio Team System 2008 Database Edition GDR R2 implements support for SQL Server 2008.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=bb3ad767-5f69-4db9-b1c9-8f55759846ed

Microsoft Application Compatibility Toolkit

The Microsoft Application Compatibility Toolkit (ACT) version 5.5 contains the necessary tools and documentation to evaluate and mitigate application compatibility issues before deploying Windows 7, Windows Vista®, a Windows Update, or a new version of Windows® Internet Explorer® in your environment.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=24da89e9-b581-47b0-b45e-492dd6da2971

Microsoft BizTalk Adapter for SQL Server Installation Guide and Help

Download the latest installation instructions and Help for the BizTalk Adapter for SQL Server.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=f6a520b2-1804-4c17-a73d-b6377fecc40d

SQL Server Driver for PHP Version 1.0 Cumulative Update - April 2009

Download the SQL Server Driver for PHP Version 1.0 Cumulative Update - April 2009.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=61bf87e0-d031-466b-b09a-6597c21a2e2a

Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for Developers

Download SQL Server 2008 180-day Trial Software. Microsoft SQL Server 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data analysis and reporting solutions.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=6b10c7c1-4f97-42c4-9362-58d4d088cd38

Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals

Download SQL Server 2008 180-day Trial Software. Microsoft SQL Server 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data analysis and reporting solutions.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=265f08bc-1874-4c81-83d8-0d48dbce6297

New KB's

Other

SQL Svr Compact Edtn 3.5 AL: FIX: An error message is logged, and the synchronization may take a long time to finish when you synchronize a merge replication that contains a SQL Server Compact 3.5 subscriber: "UpdateStatistics Start app=<UserAppName>.exe" (Updated)

https://support.microsoft.com/kb/963060/EN-US

SQL Svr Compact Edtn 3.5 AL: FIX: Error message when you run a query in SQL Server Compact 3.5: "The column name cannot be resolved to a table. Specify the table to which the column belongs"

https://support.microsoft.com/kb/968864/EN-US

SQL 2000

SQL Svr Enterprise Edtn 2000 EN: How to impede Windows NT administrators from administering a clustered instance of SQL Server (Updated)

https://support.microsoft.com/kb/263712/EN-US

SQL Svr Standard Edtn 2000 EN: MS08-040: Description of the security update for SQL Server 2000 QFE and MSDE 2000: July 8, 2008 (Updated)

https://support.microsoft.com/kb/948111/EN-US

SQL 2005

JDBC Driver for SQL Server 2005: FIX: A SQL Server 2005-based application cannot connect to a mirrored database by using the JDBC driver 1.2 after the first successful connection

https://support.microsoft.com/kb/968951/EN-US

JDBC Driver for SQL Server 2005: FIX: The certificate that was used to sign classes in the Microsoft SQL Server JDBC driver has expired in SQL Server JDBC Driver versions 1.0, 1.1, and 1.2

https://support.microsoft.com/kb/969619/EN-US

SQL Server 2005 Service Pack 2: You cannot install SQL Server 2005 Service Pack 2 when the database file of the Resource database is not in the same folder as the log file of the Resource database (Updated)

https://support.microsoft.com/kb/947989/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 and in SQL Server 2008 Analysis Services: "OLE DB error: OLE DB or ODBC error: An unexpected token "WITH" was found following "<Query>"" (Updated)

https://support.microsoft.com/kb/959026/EN-US

SQL Svr 2005 Analysis Svcs EN: FIX: Error message when you run a series of the CREATE SESSION CUBE statement and the DROP SESSION CUBE statement in SQL Server 2005 Analysis Services: "An unexpected exception occurred" (Updated)

https://support.microsoft.com/kb/967348/EN-US

SQL Svr 2005 Analysis Svcs EN: FIX: Error message when you synchronize a database in SQL Server 2005 Analysis Services: "Errors in the metadata manager. The dimension with ID of '<Dimension ID>', Name of '<Dimension Name>' referenced by the '<Cube Name>' cube, does not exist" (Updated)

https://support.microsoft.com/kb/967625/EN-US

SQL Svr 2005 Analysis Svcs EN: 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

https://support.microsoft.com/kb/968290/EN-US

SQL Svr 2005 Analysis Svcs EN: FIX: The SQL Server 2005 Analysis Services service crashes when you process dimensions in a cube that contains a calculation script by using the Process Update option

https://support.microsoft.com/kb/968398/EN-US

SQL Svr 2005 Analysis Svcs EN: 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

https://support.microsoft.com/kb/968900/EN-US

SQL Svr 2005 Analysis Svcs EN: FIX: Error message occurs unexpectedly at different times in a SQL Server 2005 Analysis Services database that uses user-defined functions: "The <Function Name> function does not exist"

https://support.microsoft.com/kb/969123/EN-US

SQL Svr 2005 Analysis Svcs EN: 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

https://support.microsoft.com/kb/969588/EN-US

SQL Svr 2005 Reporting Svcs EN: FIX: Error message when you try to export a report to a PDF file in SQL Server 2005 Reporting Services: "Non-negative number required" (Updated)

https://support.microsoft.com/kb/967618/EN-US

SQL Svr Compact Edtn 2005 EN: FIX: An error message is logged, and the synchronization may take a long time to finish when you use an application to synchronize a merge replication that contains a SQL Server 2005 Compact Edition subscriber (Updated)

https://support.microsoft.com/kb/960142/EN-US

SQL Svr Compact Edtn 2005 EN: FIX: Error message when you try to create an encrypted database of SQL Server 2005 Compact Edition: "The operating system does not support encryption"

https://support.microsoft.com/kb/968171/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: FIX: The SQL Server 2005 Setup program may take much longer than expected to finish running (Updated)

https://support.microsoft.com/kb/910070/EN-US

SQL Svr Enterprise Edtn 2005 EN: FIX: The SQL Server engine in SQL Server 2005 may consume large amounts of memory during the setup configuration phase

https://support.microsoft.com/kb/967522/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Error message when you try to install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 from the existing active node: "The product instance <InstanceName> has been patched with more recent updates" (Updated)

https://support.microsoft.com/kb/934749/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections (Updated)

https://support.microsoft.com/kb/937745/EN-US

SQL Svr Standard Edtn 2005 EN: 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" (Updated)

https://support.microsoft.com/kb/944390/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: The size of a database keeps increasing when you perform many DELETE operations and many INSERT operations on the database in SQL Server 2005 (Updated)

https://support.microsoft.com/kb/953991/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 and in SQL Server 2008 (Updated)

https://support.microsoft.com/kb/959001/EN-US

SQL Svr Standard Edtn 2005 EN: 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" (Updated)

https://support.microsoft.com/kb/959025/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: FIX: When you run a query that uses the NOLOCK table hint in SQL Server 2005 to retrieve BLOB data, the query runs very slowly

https://support.microsoft.com/kb/961049/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: When you run a query that has a parallel execution plan in parallel under the READ COMMITTED isolation level on a database that is set the READ COMMITTED SNAPSHOT option in SQL Server 2005, the query that you may obtain may return uncommitted data

https://support.microsoft.com/kb/961050/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run a DML statement in a LINQ to SQL application in SQL Server 2008: "The target table '<Table Name>' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause"

https://support.microsoft.com/kb/961073/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: When you insert a string to a table by using the SQL Native Client (SNAC) OLE DB provider or the SNAC ODBC provider in a SQL Server 2005-based application, the string is truncated (Updated)

https://support.microsoft.com/kb/961396/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: The tempdb database is corrupted when you start some transactions that use the snapshot isolation level on a database that has row versioning enabled in SQL Server 2005 (Updated)

https://support.microsoft.com/kb/961739/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: The CPU usage and the memory usage increase gradually and many session IDs are in the dormant status in SQL Server 2005

https://support.microsoft.com/kb/961811/EN-US

SQL Svr Standard Edtn 2005 EN: 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

https://support.microsoft.com/kb/965217/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: The performance of database mirroring decreases when you run a database maintenance job that generates a large number of transaction log activities in SQL Server 2005

https://support.microsoft.com/kb/967101/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Error message when you open Replication Monitor for a transactional publication in SQL Server 2005: "Initial snapshot for publication <PublicationName> is not available" (Updated)

https://support.microsoft.com/kb/967192/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: The Wmiprvse.exe host process stops responding when you run a SQL Server 2005-based application that sends a Windows Management Instrumentation (WMI) query to the SQL Server WMI provider

https://support.microsoft.com/kb/967199/EN-US

SQL Svr Standard Edtn 2005 EN: 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

https://support.microsoft.com/kb/967206/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: The values of some SQL Server 2005 SSIS pipeline counters are always 0 when you try to view them in a terminal session (Updated)

https://support.microsoft.com/kb/967316/EN-US

SQL Svr Standard Edtn 2005 EN: 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

https://support.microsoft.com/kb/967337/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Error message when you apply a snapshot file that is exactly divisible by 1 MB in SQL Server 2005: "The process could not bulk copy into table dbo.<tablename>. (Source: MSSQLServer, Error number: 20253)" (Updated)

https://support.microsoft.com/kb/967527/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: An empty result set is returned when you run an SSIS package that contains an Execute SQL task in SQL Server 2005 Service Pack 2 (Updated)

https://support.microsoft.com/kb/967570/EN-US

SQL Svr Standard Edtn 2005 EN: Cumulative update package 13 for SQL Server 2005 Service Pack 2

https://support.microsoft.com/kb/967908/EN-US

SQL Svr Standard Edtn 2005 EN: Cumulative update package 3 for SQL Server 2005 Service Pack 3

https://support.microsoft.com/kb/967909/EN-US

SQL Svr Standard Edtn 2005 EN: 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

https://support.microsoft.com/kb/967983/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Error message after you configure a peer-to-peer transactional replication and then apply SQL Server 2005 Service Pack 3: "The process could not allocate memory. (Source: MSSQL_REPL, Error number: MSSQL_REPL20001)"

https://support.microsoft.com/kb/968079/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: A SQL Server 2005 database becomes offline unexpectedly when you run an application that uses service broker on this database

https://support.microsoft.com/kb/968233/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: All records in the query log table are truncated when you synchronize a database in SQL Server 2005

https://support.microsoft.com/kb/968381/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: A query that runs in parallel on a multiprocessor computer returns incorrect results in SQL Server 2005

https://support.microsoft.com/kb/968449/EN-US

SQL Svr Standard Edtn 2005 EN: SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed (Updated)

https://support.microsoft.com/kb/968749/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Error message when you send an e-mail by using Database Mail in SQL Server 2005: "The operation has timed out"

https://support.microsoft.com/kb/968834/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: An access violation occurs when a peer-to-peer transactional replication is under stress in SQL Server 2005

https://support.microsoft.com/kb/968906/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: When you convert a TEXT column to a VARCHAR(MAX) column, an NTEXT column to a NVARCHAR(MAX) column, or an IMAGE column to a VARBINARY(MAX) column, the original NULL values in these columns may become empty strings in SQL Server 2005

https://support.microsoft.com/kb/968914/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: A query that contains the IS NOT NULL clause returns an incorrect result in SQL Server 2005

https://support.microsoft.com/kb/969021/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: "Unable to deallocate a kept page" (Updated)

https://support.microsoft.com/kb/969142/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run a query that uses the CASE function in SQL Server 2005: "Conversion failed when converting the <DateType> value '<Value>' to data type <DataType>"

https://support.microsoft.com/kb/969466/EN-US

SQL Svr Standard Edtn 2005 EN: FIX: Distribution Agent fails when you try to apply a snapshot for a newly added view in a publication in SQL Server 2005

https://support.microsoft.com/kb/969775/EN-US

SQL Svr Std Edtn 2005 64Bit EN: How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server 2005 and in SQL Server 2008 (Updated)

https://support.microsoft.com/kb/914288/EN-US

SQL Svr Std Edtn 2005 64Bit EN: FIX: SQL Server 2005 or SQL Server 2008 may stop responding when you are performing a backup (Updated)

https://support.microsoft.com/kb/960543/EN-US

SQL Svr Std Edtn 2005 64Bit EN: FIX: Error message when you run a query in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan"

https://support.microsoft.com/kb/961106/EN-US

SQL 2008

SQL Svr Developer 2008 EN: SQL Server 2008 setup may fail with "Setup Failure in SetupActionName: gatherusersettings" error message

https://support.microsoft.com/kb/969914/EN-US

SQL Svr Enterprise 2008 EN: How to update or slipstream a failed installation of SQL Server 2008 (Updated)

https://support.microsoft.com/kb/955392/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 (Updated)

https://support.microsoft.com/kb/955963/EN-US

SQL Svr Enterprise 2008 EN: FIX: Error message when you estimate the compression on a table in SQL Server 2008: "Subquery returned more than 1 value" (Updated)

https://support.microsoft.com/kb/956031/EN-US

SQL Svr Enterprise 2008 EN: How do I open the firewall port for SQL Server on Windows Server 2008?

https://support.microsoft.com/kb/968872/EN-US

SQL Svr Enterprise 2008 EN: Various memory errors are logged to SQL Server error log when using SQL CLR objects

https://support.microsoft.com/kb/969962/EN-US

SQL Svr Express Edition 2008 AL: FIX: The default instance name is set incorrectly to SQLEXPRESS when you install SQL Server 2008 Express (Updated)

https://support.microsoft.com/kb/958778/EN-US

SQL Svr Standard 2008 EN: How to configure SQL Server 2008 Analysis Services and SQL Server 2005 Analysis Services to use Kerberos authentication (Updated)

https://support.microsoft.com/kb/917409/EN-US

SQL Svr Standard 2008 EN: 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 (Updated)

https://support.microsoft.com/kb/955769/EN-US

SQL Svr Standard 2008 EN: FIX: The About, Execute, and Close buttons are missing when you run the Execute Package Utility in the Chinese (Taiwan) version of Microsoft SQL Server 2008 (Updated)

https://support.microsoft.com/kb/956021/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 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" (Updated)

https://support.microsoft.com/kb/960806/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" (Updated)

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 (Updated)

https://support.microsoft.com/kb/961271/EN-US

SQL Svr Standard 2008 EN: FIX: A SQL Server 2008 Reporting Services report is displayed incorrectly in Mozilla Firefox if the report is displayed by using the ReportViewer control (Updated)

https://support.microsoft.com/kb/961633/EN-US

SQL Svr Standard 2008 EN: 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" (Updated)

https://support.microsoft.com/kb/962900/EN-US

SQL Svr Standard 2008 EN: 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 (Updated)

https://support.microsoft.com/kb/963070/EN-US

SQL Svr Standard 2008 EN: FIX: PAGE compression is removed from a SQL Server 2008 data table after you shrink the database (Updated)

https://support.microsoft.com/kb/963658/EN-US

SQL Svr Standard 2008 EN: FIX: When you process a full-text catalog in SQL Server 2005 and in SQL Server 2008, the operation stops responding (Updated)

https://support.microsoft.com/kb/967984/EN-US

SQL Svr Standard 2008 EN: List of the bugs that are fixed in SQL Server 2008 Service Pack 1 (Updated)

https://support.microsoft.com/kb/968369/EN-US

SQL Svr Standard 2008 EN: How to obtain the latest service pack for SQL Server 2008

https://support.microsoft.com/kb/968382/EN-US

SQL Svr Standard 2008 EN: 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

https://support.microsoft.com/kb/968587/EN-US

SQL Svr Standard 2008 EN: 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"

https://support.microsoft.com/kb/968599/EN-US

SQL Svr Standard 2008 EN: 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 (Updated)

https://support.microsoft.com/kb/968693/EN-US

SQL Svr Standard 2008 EN: FIX: The system objects may not be checked as expected when you use different policy evaluation modes in SQL Server 2008

https://support.microsoft.com/kb/968828/EN-US

SQL Svr Standard 2008 EN: 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"

https://support.microsoft.com/kb/968829/EN-US

SQL Svr Standard 2008 EN: 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

https://support.microsoft.com/kb/968830/EN-US

SQL Svr Standard 2008 EN: FIX: SQL Server 2008 Setup fails if you installed the security update package 954459 for MSXML Core Services 6.0

https://support.microsoft.com/kb/969672/EN-US

SQL Svr Standard 2008 EN: The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released

https://support.microsoft.com/kb/970365/EN-US

SQL Svr Standard 2008 EN: Updates to Microsoft SQL server 2008 will fail after an edition upgrade

https://support.microsoft.com/kb/970608/EN-US