September 2010 – Technical Rollup Mail – SQL Server
News
Microsoft announces SQL Server Migration Assistant for MySQL
Migrate from MySQL to SQL Azure or SQL Server with ease!
Microsoft Services Launches New Offerings for Mission Critical Customers
Customers running mission critical solutions have asked Microsoft to provide higher levels of service and support for their environments, given the potential negative impact to their business if an incident or outage occurs to their mission critical solution. With that in mind, Microsoft Services today announced an enhanced Premier Mission Critical add-on for customers running business critical solutions on the Microsoft platform.
Microsoft Drivers for PHP for SQL Server 2.0 released!!
Microsoft is announcing an important interoperability milestone: the release of the Microsoft Drivers for PHP for SQL Server 2.0!!
Other
https://blogs.technet.com/trm/default.aspx
Downloads
SQL 2005
SSMA for Sybase v4.2
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Sybase ASE to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.
SSMA for MySQL v1.0
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
SSMA for Access v4.2
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
SSMA for Oracle v4.2
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Oracle to SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2.
SQL 2008
SSMA for Sybase v4.2
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Sybase ASE to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.
SSMA for MySQL v1.0
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
SSMA for Access v4.2
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
SSMA for Oracle v4.2
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Oracle to SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2.
New KB's
Other
Azure SQL Service: Database Migration To Sql Azure
https://support.microsoft.com/kb/2212855/en-US
Azure SQL Service: Database Migration To Sql Azure
https://support.microsoft.com/kb/2212990/en-US
Azure SQL Service: Developing Applications For Sql Azure
https://support.microsoft.com/kb/2213496/en-US
SQL 2005
Microsoft SQL Server 2005 Analysis Services: FIX: A calculated member that uses filtered dimension members returns an incorrect result in SSAS 2005, SSAS 2008 R2 or SSAS 2008
https://support.microsoft.com/kb/981867/en-US
Microsoft SQL Server 2005 Developer Edition: FIX: Various issues occur when a database is involved in a database mirroring session and in a transactional replication if trace flag 1448 is enabled
https://support.microsoft.com/kb/983480/en-US
Microsoft SQL Server 2005 Reporting Services: User permission assigned through Active Directory Group may fail to access Reporting services reports in SharePoint
https://support.microsoft.com/kb/2276625/en-US
Microsoft SQL Server 2005 Service Pack 3: FIX: An error occurs when you update the schema of objects that are in a published database in SQL Server 2005 SP3 or SQL Server 2008
https://support.microsoft.com/kb/981811/en-US
Microsoft SQL Server 2005 Service Pack 3: FIX: SQL Server 2005 or SQL Server 2008 may require a long time to complete an ALTER TABLE statement that alters an XML data type column from "NOT NULL" to "NULL" in a table
https://support.microsoft.com/kb/982363/en-US
Microsoft SQL Server 2005 Service Pack 3: FIX: A deadlock occurs when you run a query or a stored procedure that contains an XML column in SQL Server 2005 or SQL Server 2008
https://support.microsoft.com/kb/983429/en-US
Microsoft SQL Server 2005 Service Pack 3: FIX: The role synchronization process is delayed when a mirroring automatic failover occurs in SQL Server 2005 or SQL Server 2008
https://support.microsoft.com/kb/983500/en-US
Microsoft SQL Server 2005 Service Pack 3: FIX: Error message when you use database mirroring in SQL Server 2005 or SQL Server 2008, and an assertion failure occurs intermittently
https://support.microsoft.com/kb/983564/en-US
Microsoft SQL Server 2005 Standard Edition: All records in the query log table are truncated when you synchronize a database in SQL Server Analysis Services
https://support.microsoft.com/kb/968381/en-US
Microsoft SQL Server 2005 Standard Edition: FIX: Error message when you run a SQL Server 2005 or SQL Server 2008 Integration Services package (SSIS) after you install the .NET Framework 2.0 SP2 or the .NET Framework 3.5 SP1: "ADO NET Source [1424]"
https://support.microsoft.com/kb/969845/en-US
Microsoft SQL Server 2005 Standard Edition: FIX: A DateTime value is replaced by a NULL value when a conflict is resolved by using a custom resolver in Microsoft SQL Server 2008 or Microsoft SQL Server 2005 merge replication
https://support.microsoft.com/kb/979212/en-US
Microsoft SQL Server 2005 Standard Edition: FIX: You receive a "Provider Load Failure" error message or the Wmiprvse.exe process stops responding when you use a SQL Server 2005 or SQL Server 2008 WMI provider to obtain information about SQL Server 2005 or SQL Server 2008 services
https://support.microsoft.com/kb/980142/en-US
Microsoft SQL Server 2005 Standard Edition: FIX: You experience high latency for peer-to-peer distribution agents in SQL Server 2005 or SQL Server 2008
https://support.microsoft.com/kb/980849/en-US
Microsoft SQL Server 2005 Standard Edition: FIX: Proactive caching starts unexpectedly when you insert data in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008
https://support.microsoft.com/kb/980883/en-US
Microsoft SQL Server 2005 Standard Edition: FIX: Metadata is corrupted when you move SSAS 2005, SSAS 2008 R2 or SSAS 2008 data folders from one computer to another computer
https://support.microsoft.com/kb/980948/en-US
Microsoft SQL Server 2005 Standard Edition: FIX: A query that uses a parallel query plan returns different results every time that you run the query in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008
https://support.microsoft.com/kb/981502/en-US
Microsoft SQL Server 2005 Standard Edition: FIX: A query returns an incorrect result if it uses an index that is being rebuilt online in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008
https://support.microsoft.com/kb/981713/en-US
Microsoft SQL Server 2005 Standard Edition: FIX: "Deadlock monitor failed to resolve this deadlock. Server may require restart to recover from this condition" error message when a database is being recovered in SQL Server 2005 or SQL Server 2008
https://support.microsoft.com/kb/981888/en-US
Microsoft SQL Server 2005 Standard Edition: FIX: A non-yielding scheduler error or an error 8623 occurs when you run a query that contains a large IN clause in SQL Server 2005 or SQL Server 2008
https://support.microsoft.com/kb/982376/en-US
SQL 2008
Microsoft SQL Server 2008 Analysis Services: FIX: "Internal error: An unexpected exception occurred" error message when you run a Multidimensional Expressions (MDX) query by using time intelligence in Microsoft SQL Server Analysis Services 2008
https://support.microsoft.com/kb/2152148/en-US
Microsoft SQL Server 2008 Analysis Services: FIX: MDX query triggers a "#Error CellPermission (1, 5) The MDX function CURRENTMEMBER failed" error in SQL Server 2008 Analysis Services
https://support.microsoft.com/kb/2184384/en-US
Microsoft SQL Server 2008 Analysis Services: FIX: Error message when you run a MDX query in SSAS 2008
https://support.microsoft.com/kb/2200755/en-US
Microsoft SQL Server 2008 Analysis Services: A SQL Server 2008 or SQL Server 2005 Analysis Services ROLAP query returns incorrect results
https://support.microsoft.com/kb/2216472/en-US
Microsoft SQL Server 2008 Analysis Services: FIX: Complex calculations in a query in SQL Server 2008 Analysis Services return incorrect results
https://support.microsoft.com/kb/2222267/en-US
Microsoft SQL Server 2008 Analysis Services: FIX: MDX queries experience slow performance when a new SSAS role user connects to the SSAS database in SQL Server 2008 Analysis Services
https://support.microsoft.com/kb/2253635/en-US
Microsoft SQL Server 2008 Analysis Services: A query returns inconsistent results before the data cache is warmed up in SSAS 2008
https://support.microsoft.com/kb/2255410/en-US
Microsoft SQL Server 2008 Analysis Services: 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
Microsoft SQL Server 2008 Analysis Services: FIX: The translation feature does not work when you perform a grouping action in an Excel PivotTable that uses SSAS 2008 as the data source
https://support.microsoft.com/kb/982034/en-US
Microsoft SQL Server 2008 Developer: FIX: An incorrect result is returned when you run a Transaction-SQL query against a database in Microsoft SQL Server 2008
https://support.microsoft.com/kb/2028755/en-US
Microsoft SQL Server 2008 Developer: FIX: An index corruption occurs when you update a view in Microsoft SQL Server 2008
https://support.microsoft.com/kb/2248999/en-US
Microsoft SQL Server 2008 Developer: FIX: Polish word breaker causes a Full-Text query to return an incomplete result in SQL Server 2008
https://support.microsoft.com/kb/980350/en-US
Microsoft SQL Server 2008 Developer: FIX: "A system assertion check has failed" error message when you run a Transaction-SQL query in Microsoft SQL Server 2008
https://support.microsoft.com/kb/980832/en-US
Microsoft SQL Server 2008 Developer: Microsoft JDBC Driver 2.0 cannot connect to SQL Server 2008 from a FIPS-enabled IBM WebSphere application
https://support.microsoft.com/kb/982512/en-US
Microsoft SQL Server 2008 Developer: FIX: Error message when you configure a transactional replication for a database in SQL Server 2008
https://support.microsoft.com/kb/982857/en-US
Microsoft SQL Server 2008 Enterprise: SQL Server 2008 setup fails to install on a Windows Server 2008-based cluster mount point
https://support.microsoft.com/kb/2216461/en-US
Microsoft SQL Server 2008 Enterprise: The SQL Dumper utility cannot generate error dump files on a SQL Server 2008 failover cluster on an Advanced/Enterprise Failover Cluster install
https://support.microsoft.com/kb/2216491/en-US
Microsoft SQL Server 2008 Enterprise: FIX: Multiserver jobs are not downloaded from SQL Server 2000 in the MSX role to SQL Server 2008 in the TSX role
https://support.microsoft.com/kb/2216501/en-US
Microsoft SQL Server 2008 Enterprise: FIX: An incorrect cardinality estimate is returned When you run a query in Microsoft SQL Server 2008
https://support.microsoft.com/kb/2222998/en-US
Microsoft SQL Server 2008 Enterprise: How to troubleshoot SQL Server 2008 Setup issues
https://support.microsoft.com/kb/955396/en-US
Microsoft SQL Server 2008 Enterprise: FIX: "Fulltext index error during compression or decompression" error message when you rebuild the full-text search index in Microsoft SQL Server 2008
https://support.microsoft.com/kb/980570/en-US
Microsoft SQL Server 2008 Enterprise: FIX: "There is insufficient system memory in resource pool 'internal' to run this query" error message when you run a full-text query that uses compound words in Microsoft SQL Server 2008
https://support.microsoft.com/kb/982854/en-US
Microsoft SQL Server 2008 Enterprise: FIX: The export process never finishes when you export a report that has nested tablix items in Microsoft SQL Server Reporting Services 2008 to the extensions that are supported by the hard page-break renderers
https://support.microsoft.com/kb/983577/en-US
Microsoft SQL Server 2008 Reporting Services: FIX: Blank spaces between some items are generated incorrectly in a SQL Server 2008 report
https://support.microsoft.com/kb/2028406/en-US
Microsoft SQL Server 2008 Reporting Services: FIX: A SQL Server 2005 report that uses the visibility toggles feature runs incorrectly in SQL Server 2008
https://support.microsoft.com/kb/2220252/en-US
Microsoft SQL Server 2008 Reporting Services: FIX: The Reporting Services service stops unexpectedly after you apply SQL Server 2008 SP1 CU 7 or CU8
https://support.microsoft.com/kb/2231277/en-US
Microsoft SQL Server 2008 Reporting Services: A SSRS 2008 report shows duplicate first row for each group of a subreport when you export the report to CSV format
https://support.microsoft.com/kb/983446/en-US
Microsoft SQL Server 2008 Service Pack 1: FIX: Error message when you enable TDE on a database that has the snapshot isolation enabled in SQL Server 2008
https://support.microsoft.com/kb/981120/en-US
Microsoft SQL Server 2008 Service Pack 1: FIX: You cannot run Data Profile Viewer to open a data profile in SQL Server 2008 when the server does not have the Integration Services component installed
https://support.microsoft.com/kb/982564/en-US
Microsoft SQL Server 2008 Standard: SQL Server may report an 18272 error during restore operations
https://support.microsoft.com/kb/2022254/en-US
Microsoft SQL Server 2008 Standard: Cumulative update package 9 for SQL Server 2008 Service Pack 1
https://support.microsoft.com/kb/2083921/en-US
Microsoft SQL Server 2008 Standard: SQL Server is not supported on Windows Server 2003 or Windows Server 2008 Terminal Server application server
https://support.microsoft.com/kb/327270/en-US
Microsoft SQL Server 2008 Standard: Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment
https://support.microsoft.com/kb/956893/en-US
Microsoft SQL Server 2008 Standard: List of the bugs that are fixed in SQL Server 2008 Service Pack 2
https://support.microsoft.com/kb/979450/en-US
Microsoft SQL Server 2008 Workgroup: Diagnosing and Troubleshooting SQL Server Performance Problems
https://support.microsoft.com/kb/982870/en-US
SQL 2008 R2
Microsoft SQL Server 2008 R2 Analysis Services: Error message when you install SQL Server 2008 R2 before you run the PreRequisiteInstaller.exe tool
https://support.microsoft.com/kb/2261507/en-US
Microsoft SQL Server 2008 R2 Datacenter: FIX: A full-text query that uses CONTAINS or FREETEXT predicate together with the "OR" operator takes a long time to run in SQL Server 2008
https://support.microsoft.com/kb/2264562/en-US
Microsoft SQL Server 2008 R2 Datacenter: The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released