Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mani_12345
Starting Member
35 Posts |
 Posted - 2012-05-29 : 05:45:38
|
| i have created master key .now i like to drop it but it showing u dont have a control permssion for same ...help to solve ths prbm |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-05-30 : 04:09:40
|
| What is the exact query you have used to drop the master key?Check this query: DROP MASTER KEYNote:1. The drop will fail if any private key in the database is protected by the master key.2. Requires CONTROL permission on the database.Ref: http://msdn.microsoft.com/en-us/library/ms180071.aspx |
 |
|
|
mani_12345
Starting Member
35 Posts |
Posted - 2012-05-30 : 05:42:41
|
| thnx for response bt i have tried this query this shows :Requires CONTROL permission on the database so how to solve this prbm |
|
|
|
granuharmot
Starting Member
31 Posts |
Posted - 2014-09-23 : 05:16:55
|
| unspammed |
|
|
|
|
|
|
Master key