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.

sp_helpdb – the syntax is the following, where database_name is the name of the database:
```
sp_helpdb database_name
```
dbencryption_status – use status to get information on whether a database is encrypted, and progress to find out how far along the encryption process has gone:
- ```
select dbencryption_status(“status”, db_id(“existdb”))
```
- ```
select dbencryption_status(“progress”, db_id(“existdb”))
```