To View List of Encrypted Databases
security-audit #database#encryption#security-audit
select * from sys.dm_database_encryption_keys where encryption_state = 3;
go
--note: by default if we encrypt any database, tempdb will also get encrypted.select * from sys.dm_database_encryption_keys where encryption_state = 3;
go
--note: by default if we encrypt any database, tempdb will also get encrypted.