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 |
|
learntsql
524 Posts |
 Posted - 2010-03-10 : 03:04:23
|
| Hi All,How can i delete the Symmetric/ASymmetric Keys FROM sys.symmetric_keys TABLE.While i am trying getting error as "Ad hoc updates to system catalogs are not allowed."My Actual intension is 1.Once i create any key I use that key to encrypt the data and i remove/delete from database.i.e i dont want to store at anywhere.2.While decrypting the data i once again create the same and use it for decrypt and i remove it permanantly from database.How to do this?Is there any other ways where these perticuler keys are secured.Please guide me.TIA. |
|
|
learntsql
524 Posts |
Posted - 2010-03-12 : 01:08:18
|
| Any updates...plz... |
 |
|
|
|
|
|
Symmetric/ASymmetric Keys deletion