TODO:
Have you ever wanted to change the password associated with your Database Master Key?
SOLUTION:
use my database
GO
--step 1, open the key
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'my password'
GO
--step 2, regenerate it with new password
ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD 'new password'
GO
NOTES:
There are no notes on this topic.