Encryption Status and Progress

To obtain information on whether a database is encrypted or not, as well as how far along the encryption process has gone on a database being encrypted, use the sp_helpdb system procedure or the dbencryption_status built-in function.