Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the 'Applies to' section.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:ĩ81356 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released Status We recommend that you consider applying the most recent fix release that contains this hotfix. For more information about how to obtain this cumulative update package for SQL Server 2008 R2, click the following article number to view the article in the Microsoft Knowledge Base:Ģ261464 Cumulative update package 3 for SQL Server 2008 R2Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release. The fix for this issue was first released in Cumulative Update 3. First, the Detach/Reattach method relies on SQL Agent (presumably to copy the data and log files from source to destination), and SMO has been removed from 2008 R2, so that method is also unavailable in Express 2008 R2. Unable to debug SQL Server 2008 Stored Procedure from SQL Management Studio. This is due to the fact that the two primary means of executing this task are unavailable in SQL Server Express Edition.

This fix enables you to rename SQL Azure databases in Object Explorer. Browse other questions tagged sql-server-2008-r2 or ask your own question. Since SQL Azure Service Update 2, SQL Azure supports the 'ALTER DATABASE' statement to rename databases. SymptomsĪ fix is available for SQL Server Management Studio (SSMS) 2008 R2 that enables users to rename SQL Azure databases in Object Explorer. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release. Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. SQL Server 2008 R2 SQL Server Management Studio SQL Server 2008 R2 Service Pack 3 More.

Sql management studio 2008 r2