Create a gist now

Instantly share code, notes, and snippets.

Embed
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
GO
--View the symmetric keys
SELECT
[name]
, [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