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