Article ID: 2563828 - View products that this article applies to.
Consider the following scenario:
Service pack information for SQL Server 2008 R2To resolve this problem, obtain the latest service pack for SQL Server 2008 R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2527041After you apply the fix, a user cannot drop the server certificate if the certificate is used to help secure a database encryption key (DEK).
(http://support.microsoft.com/kb/2527041/ )How to obtain the latest service pack for SQL Server 2008 R2
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem was first corrected in SQL Server 2008 R2 Service Pack 1 (SP1).
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/968382/ )Description of the standard terminology that is used to describe Microsoft software updates