sp_helpdb

The sp_helpdb system procedure supports the full database encryption feature.

When you run sp_helpdb on a fully encrypted database, it reports its encryption status:

Encrypted
Encryption in progress
Decryption in progress

If the database is being encrypted or decrypted, sp_helpdb reports the percentage of work that has completed.

Examples

Example 1

Reports the status of database that is being encrypted:

>sp_helpdb
>go
name        db_size    owner dbid  created      durability
    lobcomplvl inrowlen
status
……
test_db     6.0 MB     sa       4  Aug 07, 2013 full
             0 NULL
    encryption in progress: 35%
……

Example 2

Reports the status of a partially encrypted database:

>sp_helpdb
>go
name        db_size    owner dbid  created      durability
    lobcomplvl inrowlen
status
……
test_db     6.0 MB     sa       4  Aug 07, 2013 full
             0 NULL
    encrypted partly

……

Example 3

Reports the status of a database that is partially decrypted:

>sp_helpdb
>go
name        db_size    owner dbid  created      durability
    lobcomplvl inrowlen
status
……
test_db     6.0 MB     sa       4  Aug 07, 2013 full
             0 NULL
    decrypted partly

……