Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
--Be sure to select master DB and click "New Query" before runnig this
SELECT [name], is_master_key_encrypted_by_server, is_encrypted
FROM master.sys.databases
--View the symmetric keys
, [principal_id]
, [algorithm_desc]
, [create_date]
FROM MASTER.sys.symmetric_keys
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.