Skip to content

Instantly share code, notes, and snippets.

@mikerodionov

mikerodionov/Check_TDE_status.sql

Created May 30, 2018 17:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mikerodionov/523cd00bbb2ae0dbcb5db8e20f07dc16 to your computer and use it in GitHub Desktop.
Save mikerodionov/523cd00bbb2ae0dbcb5db8e20f07dc16 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Check_TDE_status.sql
--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