Search results matching tag 'service pack'

Cumulative Update package 11 for SQL Server 2008 R2 is available for download

sqlmaster — Tue, 20 Dec 2011 15:14:00 GMT

The latest instalment of Cumulative Update package for SQL Server 2008 R2 is available for download, before implement it on production make sure you test the installation.

Build 10.50.1809.0 (cumulative update) and the parent build of this build is 10.50.1807.0.

The list of issues are as follows with their KBA:

VSTS bug number	KB article number	Description
834627	955850 (http://support.microsoft.com/kb/955850/ )	Error message when you try to use the binaries from the SQL Server System CLR Types package (SQLSysClrTypes.msi): "Unable to load DLL 'SqlServerSpatial.dll': This application has failed to start because the application configuration is incorrect"
765506	970198 (http://support.microsoft.com/kb/970198/ )	FIX: You receive an incorrect result when you run a query that uses the row_number function in SQL Server 2008 or in SQL Server 2008 R2 >
826729	2445812 (http://support.microsoft.com/kb/2445812/ )	FIX: A column that uses the DATETIME data type does not replicate to an Oracle subscriber by using a transactional replication in SQL Server 2008 or in SQL Server 2008 R2
799307	2515286 (http://support.microsoft.com/kb/2515286/ )	FIX: "There is no function '{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2
799295	2583994 (http://support.microsoft.com/kb/2583994/ )	FIX: SSIS Checkpoint restores an incorrect variable value for an Execute SQL Task item of a For Loop Container item in SSIS 2008 or in SSIS 2008 R2 if an SSIS package executes again after it fails or stops
799324	2588970 (http://support.microsoft.com/kb/2588970/ )	FIX: "Server: Msg 7359" error when you run a distributed query in SQL Server 2008 or in SQL Server 2008 R2 if a schema version is updated more than five times
776490	2590839 (http://support.microsoft.com/kb/2590839/ )	FIX: Low CPU spikes at a set interval even without user activity in SQL Server 2008 R2
799292	2591461 (http://support.microsoft.com/kb/2591461/ )	FIX: "Unexpected error from SE OLEDB interface" error when you run a full-text search query in SQL Server 2008 or in SQL Server 2008 R2
799304	2598903 (http://support.microsoft.com/kb/2598903/ )	FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2
831275	2603910 (http://support.microsoft.com/kb/2603910/ )	FIX: Backup fails in SQL Server 2008 or in SQL Server 2008 R2 if you enable change tracking on the database
847239	2616481 (http://support.microsoft.com/kb/2616481/ )	FIX: SSRS 2008 R2 report has no Export menu in Internet Explorer 9.0 if you use the out-of-box viewer page in the SharePoint Report Viewer Web Part >
834620	2618676 (http://support.microsoft.com/kb/2618676/ )	FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2 >
834617	2618680 (http://support.microsoft.com/kb/2618680/ )	FIX: "Not registered correctly" error when you use a pull subscription and the Replication Interactive Conflict Resolver
766723	2624915 (http://support.microsoft.com/kb/2624915/ )	FIX: Part of a report is not displayed when you use the Report Viewer Web Part on a SharePoint 2010 site to view a SSRS 2008 R2 report
834636	2628126 (http://support.microsoft.com/kb/2628126/ )	FIX: "Fulltext index error during compression or decompression" error when you create a full-text index in SQL Server 2008 or in SQL Server 2008 R2 if the primary key is set to a BIGINT column
831257	2629456 (http://support.microsoft.com/kb/2629456/ )	FIX: Access violation when you insert a record into a new empty partition in SQL Server 2008 or in SQL Server 2008 R2
822377	2634571 (http://support.microsoft.com/kb/2634571/ )	FIX: Slow performance when you run the CHECKDB WITH PHYSICAL_ONLY command on a large database in SQL Server 2008 R2
824538	2636425 (http://support.microsoft.com/kb/2636425/ )	FIX: Incorrect result when you concurrently update multiple Excel 2010 sheets that use PowerPivot for Excel 2010 in SQL Server 2008 R2
834639	2638448 (http://support.microsoft.com/kb/2638448/ )	FIX: Access violation when a query is compiled or recompiled in SQL Server 2008 or in SQL Server 2008 R2
836361	2644260 (http://support.microsoft.com/kb/2644260/ )	FIX: A main report is re-rendered when you click a link to view a drillthrough report in SSRS 2008 R2
846406	2649359 (http://support.microsoft.com/kb/2649359/ )	FIX: An access violation occurs in the "sqlservr!CSbMsgDispatcher::CSbReceivedDialog::AppendMsg" class in SQL Server 2008 R2
831388	2653893 (http://support.microsoft.com/kb/2653893/ )	FIX: It takes a long time to restore a database in SQL Server 2008 R2

I hope this CU11 will fix the issue in relation to my previous blog post Linked Server reporte schema changes issue.

To download and further details refer to the KBA2633145 Cumulative update package 11 for SQL Server 2008 R2.

SQL Server 2008 Service Pack 3 is released, test and upgrade your existing installations

sqlmaster — Wed, 12 Oct 2011 22:02:00 GMT

Well, its time now again for all DBAs and System Administrators out there to do some real-world testing on their SQL Server 2008 instance platform, service pack 3 for SQL Server 2008 is released now. If you are already testing the CTP version then its not a big issue to perform the test and upgrade the existing instances of 2008 version.

Once you apply the SP3 for SQL Server 2008 the version will be 10.00.5500.00 and also the download page clearly states the key enhancements out this SP3 release:

Enhanced upgrade experience from previous versions of SQL Server to SQL Server 2008 SP3. In addition, we have increased the performance & reliability of the setup experience.
In SQL Server Integration Services logs will now show the total number of rows sent in Data Flows.
Enhanced warning messages when creating the maintenance plan if the Shrink Database option is enabled.
Resolving database issue with transparent data encryption enabled and making it available even if certificate is dropped.
Optimized query outcomes when indexed Spatial Data Type column is referenced by DTA (Database Tuning Advisor).
Superior user experience with Sequence Functions (e.g Row_Numbers()) in a Parallel execution plan.

However I would recommend to go through the detailed list of new features and improvements that are included in SQL Server 2008 SP3, review the Release Notes. documentation link. Further this SP3 for SQL Server 2008 contains the cumulative updates of SQL Server 2008 SP2 cumulative update package 1 to 4, and fixes to issues that have been reported through our customer feedback platforms. These include supportability enhancements and issues that have been reported through Windows Error Reporting.

To download the respective platform service pack file go to:SQL Server 2008 SP3 and for Express version go to SQL Server 2008 SP3 Express link.

SQL Server – CTP is now available for SQL Server 2008 Service Pack 3

Vishal.Gajjar — Thu, 25 Aug 2011 11:00:00 GMT

CTP has been made available earlier this week for SQL Server 2008 SP3 on Download Center. Read this MSDN blog post to get highlights of what has been updated.

Download Links:

SQL Server 2008 SP3 CTP: http://go.microsoft.com/fwlink/?LinkId=226850

SQL Server 2008 SP3 Express CTP: http://go.microsoft.com/fwlink/?LinkId=226851

SQL Server 2008 SP3 CTP has cumulative updates up to SP2 cumulative packages 1, 2, 3 and 4 and other reported issues from customer feedback. A list of bugs that are fixed in SQL Server 2008 Service Pack 3 CTP is available in KB Article 2546945 (http://support.microsoft.com/kb/2546945).

Note: There are some known issues with this SP3 CTP and TFS 2010 SP1.

SQL Server 2008 Service Pack 3 CTP is available for testing!

sqlmaster — Wed, 24 Aug 2011 13:07:00 GMT

There is no doubt that Microsoft is keeping the DBAs busy with the frequent releases of Cumulative Update packages and CTP releases on existing (2008, 2008 R2 and Denali) versions!

Now here is the news about SQL Server 2008 Service Pack 3 CTP release from SQL Server Release Services team, this means there is no support offered from CSS and only the bugs can be reported via Microsoft SQL Server Connect website. the information is as follows:

To download the CTP files click on this SQLServer2008SP3-CTP_KB2546945 link. Please note this is for SQL Server 2008 version [10.0.nnn] only, do not waste your time in attempting to apply towards SQL Server 2008 R2 version [10.50.nnn] instance.
For the free version of SQL Server which is SQL Server Express 2008 get it from this SQL2008express which includes the SQLExpress with Advances Services package too.

KBA2546945 refers the list of issues that were fixed using Cumulative Update packages for SQL Server 2008 SP2 as follows:

Cumulative update package 1 for SQL Server 2008 SP2
Cumulative update package 2 for SQL Server 2008 SP2
Cumulative update package 3 for SQL Server 2008 SP2
Cumulative update package 4 for SQL Server 2008 SP2

The Cumulative Update package 5 for SQL Server 2008 SP2 is not included, however it may be included when the final SP3 version is released.

To keep up the list of builds that were release after SQL Server 2008 RTM then refer to KBA2402659.

Further the list of issues that are fixed with this CTP version of SP is as follows (see if any specified bug is reported by you):

VSTS bug number	KB article number	Description
611967	922578 (http://support.microsoft.com/kb/922578/ )	FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in the SQL Server 2005 Errorlog file when you use SQL Server Profile in SQL Server 2005
628427	2463682 (http://support.microsoft.com/kb/2463682/ )	FIX: A database that has transparent data encryption enabled may be marked as "suspect" if the server certificate is dropped in SQL Server 2008 R2
729461	2500042 (http://support.microsoft.com/kb/2500042/ )	"SQL Server 2008 Setup requires Microsoft .NET Framework 4.0 to be installed" error message when you apply Service Pack 2 (SP2) for SQL Server 2008
757676	2565683 (http://support.microsoft.com/kb/2565683/ )	FIX: You may receive incorrect results when you run a complex query that contains aggregates functions, join functions, and distinct functions in subqueries in a SQL Server 2008 environment
746231	2569923 (http://support.microsoft.com/kb/2569923/ )	FIX: Upload jobs of data collector quickly open and close a large number of TCP ports if the jobs upload data to a MDW database in SQL Server 2008 or in SQL Server 2008 R2
429231	2588050 (http://support.microsoft.com/kb/2588050/ )	FIX: Slipstream installation of a SQL Server 2008 service pack might fail
717065	2588453 (http://support.microsoft.com/kb/2588453/ )	FIX: Access violation when DTA runs a query against a table in SQL Server 2008 if there is an index on a spatial data type column of the table
644781	2589980 (http://support.microsoft.com/kb/2589980/ )	Fix: Incorrect results or constraint violation when you run a SELECT statement or a DML statement that uses the row_number function and a parallel execution plan in SQL Server 2008

Further the KBA2546945 confirms huge list of issues that are included in SQL2008 SP3 CTP:

VSTS bug number	Description
295196, 771825	You may receive the following warning message when you create the maintenance plan if the Shrink Database option is enabled in SQL Server 2008: "Shrinking of data files moves data and can cause fragmentation of the indexes within those files."
295750	Various diagnostic tools incorrectly report the master database for queries that were executed against other databases in SQL Server 2008.
337272	The principal Lazy Writer does not start if the 0 NUMA node contains no processor in SQL Server 2008.
444202	A user cannot change their password in SQL Server 2005 by using SQL Server Management Studio (SSMS) of SQL Server 2008.
447990	Assume an indexed view projects columns from the base and non-base tables, and assume a column from the non-base table has the same order id and type as a column of the base table. In this scenario if SQL Server 2008 SP3 CTP is installed, an error occurs instead of a partition switch.
450529	Assume that you open SSMS as a non-administrator and then you try to attach a database. In this scenario if SQL Server 2008 SP3 CTP is installed, you receive an "Access is denied" error instead of an exception.
507222	Consider the following scenario: You create a database. A query is cached for this database. You delete the database, and then you create a new database. You create the deleted database again, and then you run the query./li> In this scenario, you receive a "Read Access violation in FullXactImpBase::GetXdes xact.cpp @ 2536" error in SQL Server 2008.
546001	The fix for the issue of this bug resets the name for a table-valued parameter when you create a default value for the table-valued parameter. After you install SQL Server 2008 SP3 CTP, the TableVarElem element always has the correct name when it retrieves default values from the Temp table cache.
643903	No event notifications for database-level events might be generated when a cross-database DDL operation is performed. This issue occurs because incorrect dialog handles are used.
650111	An application cannot connect to SQL Server 2008 if a side-by-side installation of SQL Server code-named "Denali" is installed. This issue occurs because of a null pointer. When the null pointer is used, up-level instances installed on the computer are ignored. After you install SQL Server 2008 SP3 CTP, the null pointer is not used when you use SQL Server 2008 Configuration Manager.
703968	After you install SQL Server 2008 SP3 CTP, the query optimizer can handle different output values for the same input value from the CRYPT_GEN_RANDOM column.
704992	Issues for integral data conversions on x64-based operating systems. These issues occur because of the BindParameter method and of LONG data type parameters that are used by this method.
707059	Profiler might not display all the events and columns for both SQL Server Database Engine and SQL Server Analysis Services. After you install SQL Server 2008 SP3 CTP, new trace template files for SQL Server Database Engine and for SQL Server Analysis Services are generated separately.
709063	Slow performance issue occurs when you run the *mdw_purge_data_[<your MDW database name>]* data collector job to perform a DELETE operation. This issue occurs if a data collector of MicrosoftSQL Server 2008 Management Data Warehouse (MDW) is running on a large-scale MDW database.
741462	Some logs might be removed when you install SQL Server 2008 Service Package 2 (SP2) or a later version of SQL Server 2008. This issue occurs because the FireAgain flag is determined by only the external event listener.
755932	LAG and LEAD analytical functions do not work in Package and Deployment Wizard (PDW) Engine. This issue occurs because some information in the MemoXML scheme is removed.
771381	Incorrect pointer of memory object is allocated when you delete a database with a FILESTREAM filegroup.
40323	An access violation occurs when an application tries to raise the 9530 error code. This issue occurs because a NULL pointer is used.
778341	The SCOPE_IDENTITY() function might return incorrect values.
536835	Setup crashes when you install Microsoft SQL Server 2008 on a computer that has SQL Server 2000 Service Pack 3 (SP3) Online Analytical Processing (OLAP) installed. This issue occurs because SQL Server 2000 SP3 OLAP incorrectly set the version registry key to Service Pack 3.0.
544926	If you do not modify any property when you try to change the DatabaseEncryptionKey SQL Server Management Objects (SMO) object, database SMO object does not update DatabaseEncryptionKey value.
729229	After you install SQL Server 2008 SP3 CTP, results of an enumeration are not cached and are not stored in local variables to enumerate resources. Additionally, disks are validated only one time, and the results are stored for subsequent requests.
425485	After you install SQL Server 2008 SP3 CTP, all landing page links that run Setup scenarios are disabled.
700081	When an application looks up names for base counters of a ratio counter, the application has to perform a substring lookup operation that is not case-sensitive in SQL Server 2008.
281309	Incorrect CPU time when you run parallel query plans for the sys.dm_exec_query_stats table.
356915	An error occurs when internal buffers for asynchronous read operations divide a multiple-character column delimiter into two parts. After you install SQL Server 2008 SP3 CTP, the current parsing pointer is reset after buffers are switched.
645220	SQLAgent.exe does not run when a valid SQLAgent.exe command is typed at a command prompt. This issue occurs because of a permissions error for shared memory.
747046	After you install SQL Server 2008 SP3 CTP, a database is not created if the database name is the same as the name of the current database user.
769191	SQL Server 2008 SP3 CTP contains updated VER_PRODUCTLEVEL_STR and VER_PRODUCTLEVEL_WSTR global variables in the Ntverp.h file. These variables are updated to SP3.

Finally when you have downloaded the SQL2008SP3CTP make sure you test it on development/test server to see it works as expected and wait until full release of SP3 for SQL Server 2008 version. Also for the new installation you can easily SlipStream the RTM + Service Pack releases, this has been documented in BOL and my book titled: Microsoft SQL Server 2008 R2 Administration cookbook.