Encryption Status and Progress

There are two ways to find out what the encryption status is on a database.

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. The syntax is the following, where database_name is the name of the database:
```
sp_helpdb database_name
```
The dbencryption_status built-in function. 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”))
```