March 2009 - Technical Rollup Mail - SQL Server
News
Technical RollUp
https://blogs.technet.com/trm/default.aspx
Documents
Database Encryption in SQL Server 2008 Enterprise Edition
https://msdn.microsoft.com/en-us/library/cc278098.aspx
Protecting SQL Server with System Center Data Protection Manager 2007
https://go.microsoft.com/fwlink/?LinkId=123896
Predictive Analysis with SQL Server 2008
Managing Unstructured Data with SQL Server 2008
SQL Server 2008 Compared to Oracle Database 11g
Downloads
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
MSDN Webcast: Building Applications with SQL Server 2008 (Level 100)
Microsoft SQL Server 2008 adds numerous new capabilities for developers, from support for spatial data types to a mechanism to store SQL BLOB data using the NTFS file system and several things in between.
TechNet Webcast: Governing Your Enterprise with Policy-Based Management (Level 300)
Policy-Based Management is an essential new feature to maintain configuration consistency across large distributed environments, enforce strict regulatory requirements, and manage the complexity of Microsoft SQL Server instances throughout the enterprise
TechNet Webcast: SQL Server 2008 Capabilities for Meeting PCI Compliance Needs (Level 200)
Payment Card Industry Data Security Standards (PCI DSS) is a preventative standard intended to reduce the risk of payment card fraud and information theft.
Take advantage of this coaching session hosted by a Microsoft Certified Trainer to help prepare for your Microsoft Certification exam.
Take advantage of this coaching session hosted by a Microsoft Certified Trainer to help prepare for your Microsoft Certification exam.
New KB's
Other
SQL Svr Compact Edtn 3.5 AL: FIX: Error message when you run a "LINQ to Entities" query that uses a string parameter or a binary parameter against a SQL Server Compact 3.5 database: "The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses"
https://support.microsoft.com/kb/958478/EN-US
SQL Svr Compact Edtn 3.5 AL: After you execute the SqlCeEngine.Compact method against a SQL Server Compact 3.5 client database that is synchronized to a central database server, some changes to the client database may not be uploaded
https://support.microsoft.com/kb/967502/EN-US
SQL 2000
SQL Svr 2000 Desktop Engine: INF: New Switches in MSDE Service Pack 3 Setup (Updated)
https://support.microsoft.com/kb/810826/EN-US
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: BUG: Database maintenance plan on system databases fails on integrity check if "Attempt to repair minor problems" is selected (Updated)
https://support.microsoft.com/kb/290622/EN-US
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 Svr Standard Edtn 2000 EN: MS09-004: Description of the security update for SQL Server 2000 GDR and for MSDE 2000: February 10, 2009
https://support.microsoft.com/kb/960082/EN-US
SQL Svr Standard Edtn 2000 EN: MS09-004: Description of the security update for SQL Server 2000 QFE and for MSDE 2000: February 10, 2009
https://support.microsoft.com/kb/960083/EN-US
SQL Svr Standard Edtn 2000 EN: You cannot apply security update 960082 in a Windows 2000 or Windows Server 2003 environment
https://support.microsoft.com/kb/967092/EN-US
SQL Svr Standard Edtn 2000 EN: ISA Server 2004 and ISA Server 2006 may be affected by the security updates in Microsoft Knowledge Base articles 960082 and 960083
https://support.microsoft.com/kb/967094/EN-US
SQL Svr Standard Edtn 2000 EN: SharePoint users are incorrectly offered a SQL Server 2000 Desktop Engine (Windows) update when they try to install the security update in Microsoft Knowledge Base article 960082
https://support.microsoft.com/kb/967096/EN-US
SQL 2005
SQL Server 2005 Service Pack 2: MS09-004: Vulnerabilities in Microsoft SQL Server could allow remote code execution
https://support.microsoft.com/kb/959420/EN-US
SQL Server 2005 Service Pack 2: MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009
https://support.microsoft.com/kb/960089/EN-US
SQL Server 2005 Service Pack 2: MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009
https://support.microsoft.com/kb/960090/EN-US
SQL Server 2005 Service Pack 2: The Windows Internal Database (WYukon) is removed when you use the Add or Remove Programs item in Control Panel to uninstall a security update for SQL Server 2005
https://support.microsoft.com/kb/967095/EN-US
SQL Svr 2005 Analysis Svcs EN: How to configure SQL Server 2005 Analysis Services to use Kerberos authentication (Updated)
https://support.microsoft.com/kb/917409/EN-US
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 Analysis Svcs EN: FIX: Error message when you run some Multidimensional Expressions (MDX) queries that reference some calculated members in many connections at the same time in SQL Server 2005 Analysis Services: "An unexpected error occurred"
https://support.microsoft.com/kb/960971/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: Error message when you run a Multidimensional Expressions (MDX) query that contains a calculation in SQL Server 2005 Analysis Services: "An unexpected exception occurred"
https://support.microsoft.com/kb/960977/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: You cannot connect to an instance of SQL Server 2005 Analysis Services through HTTP when you configure Internet Explorer to use a .pac file
https://support.microsoft.com/kb/961146/EN-US
SQL Svr 2005 Analysis Svcs EN: 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
https://support.microsoft.com/kb/961920/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"
https://support.microsoft.com/kb/967625/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 2005 Reporting Svcs EN: FIX: You are prompted to provide the credentials when you view a history snapshot for a SQL Server 2005 Reporting Services report if you use stored credentials for the data source of the report
https://support.microsoft.com/kb/967180/EN-US
SQL Svr 2005 Reporting Svcs EN: Error message when you try to print a SQL Server 2005 Reporting Services report on a client computer: "Unable to load client print control"
https://support.microsoft.com/kb/967511/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"
https://support.microsoft.com/kb/967618/EN-US
SQL Svr Developer Edtn 2005 EN: How to use Kerberos authentication in SQL Server (Updated)
https://support.microsoft.com/kb/319723/EN-US
SQL Svr Enterprise Edtn 2005 EN: How to resolve permission issues when you move a database between servers that are running SQL Server (Updated)
https://support.microsoft.com/kb/240872/EN-US
SQL Svr Enterprise Edtn 2005 EN: How to change the SQL Server or SQL Server Agent service account without using SQL Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/283811/EN-US
SQL Svr Enterprise Edtn 2005 EN: How to move databases between computers that are running SQL Server (Updated)
https://support.microsoft.com/kb/314546/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: How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port (Updated)
https://support.microsoft.com/kb/823938/EN-US
SQL Svr Enterprise Edtn 2005 EN: You may not be able to connect to an instance of SQL Server by using an anonymous login (Updated)
https://support.microsoft.com/kb/839569/EN-US
SQL Svr Enterprise Edtn 2005 EN: SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall a security update (Updated)
https://support.microsoft.com/kb/957008/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 Express Edtn 2005 EN: Error message when you use the SQL Server Error and Usage Reporting tool on a 64-bit Windows operating system: "The Error Reports Location path name cannot be empty"
https://support.microsoft.com/kb/967598/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: The SQL Server service cannot start when you change a startup parameter for a clustered instance of SQL Server 2000 or of SQL Server 2005 to a value that is not valid (Updated)
https://support.microsoft.com/kb/912397/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: How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/917825/EN-US
SQL Svr Standard Edtn 2005 EN: You may experience a decrease in query performance after you perform certain database maintenance operations or regular transaction operations in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/917828/EN-US
SQL Svr Standard Edtn 2005 EN: Error message when you install SQL Server 2005 or SQL Server 2008: "The file C:\Windows\Microsoft.NET\Framework\[version_number]\mscorlib.tlb could not be loaded" (Updated)
https://support.microsoft.com/kb/918685/EN-US
SQL Svr Standard Edtn 2005 EN: The use of third-party detours or similar techniques is not supported in SQL Server (Updated)
https://support.microsoft.com/kb/920925/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: How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult (Updated)
https://support.microsoft.com/kb/932881/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: Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service (Updated)
https://support.microsoft.com/kb/942176/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: You cannot restore a database from a backup file when you use a SQL Server login ID that has the dbcreator server role to connect to an instance of SQL Server 2005
https://support.microsoft.com/kb/950891/EN-US
SQL Svr Standard Edtn 2005 EN: Cumulative update package 8 for SQL Server 2005 Service Pack 2 (Updated)
https://support.microsoft.com/kb/951217/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, Cumulative Update 9, or security update 954606 (security bulletin MS08-052) 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: 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: FIX: The SQL Server service stops when you run one of the DBCC CHECK commands on a SQL Server 2005 database or when you create a database snapshot for a SQL Server 2005 database
https://support.microsoft.com/kb/961123/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You cannot kill a session that is running a query on a linked server in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/961237/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
https://support.microsoft.com/kb/961396/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: An unresolved deadlock occurs when you perform an online reindex operation that runs on parallel threads in SQL Server 2005
https://support.microsoft.com/kb/961479/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: 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
https://support.microsoft.com/kb/961739/EN-US
SQL Svr Standard Edtn 2005 EN: Cumulative update package 2 for SQL Server 2005 Service Pack 3
https://support.microsoft.com/kb/961930/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A query notification is not fired correctly if the query contains inner joins and the IS NULL clause in SQL Server 2005
https://support.microsoft.com/kb/961935/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you synchronize data for a SQL Server Compact Edition subscriber in SQL Server 2005: "A call to SQL Server Reconciler failed. Try to resynchronize. HRESULT 0x80004005 (29006)"
https://support.microsoft.com/kb/962003/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run an UPDATE statement on a database that has the SNAPSHOT or READ COMMITTED SNAPSHOT isolation level enabled in SQL Server 2005: "The Database ID <Database ID>, Page (<N>:<N>), slot <N> for LOB data type node does not exist"
https://support.microsoft.com/kb/962209/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 Standard Edtn 2005 EN: Cumulative update package 12 for SQL Server 2005 Service Pack 2 (Updated)
https://support.microsoft.com/kb/962970/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The execution plan does not use the forced index when you use the INDEX optimizer hint in a query that runs against a synonym in SQL Server 2005
https://support.microsoft.com/kb/963684/EN-US
SQL Svr Standard Edtn 2005 EN: 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
https://support.microsoft.com/kb/967169/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"
https://support.microsoft.com/kb/967192/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
https://support.microsoft.com/kb/967316/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)"
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
https://support.microsoft.com/kb/967570/EN-US
SQL Svr Std Edtn 2005 64Bit EN: The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance object" list after you install Integration Services from a 64-bit version of SQL Server 2005 (Updated)
https://support.microsoft.com/kb/941154/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: Microsoft SQL Server Database Engine Input/Output Requirements
https://support.microsoft.com/kb/967576/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: 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"
https://support.microsoft.com/kb/961699/EN-US
SQL Svr Standard 2008 EN: When you attempt to install SQL Server 2008 from DVD, the Full Text Search Installation may fail if you have installed SQL Server 2008 Express Edition previously