I have a problem. We had a database promoted from dev to test via redirected restore.
The database has an encrypted column. As you can imagine, the key no longer works.
Is there a way to drop the key and recreate a new one?
Do I have to drop the key, create a new key, then update the column with the values using the encrypt function?