Encryption DMV’s

select * from sys.databases where is_master_key_encrypted_by_server=1
select * from sys.certificates
select * from sys.dm_database_encryption_keys where encryption_state=3
SELECT * FROM sys.symmetric_keys
SELECT * FROM sys.asymmetric_keys

 

Leave a Reply

Your email address will not be published. Required fields are marked *