Type:
Known Issue. Minor.
Summary:
sp_n_codelvl is an optional Encryptionizer SQL Stored Procedure which can report the encryption state of attached databases. In some cases, the report shows the encrypted database as ENCRYPTED when Offline as expected, but shows PLAIN when the encrypted database is ONLINE.
Additional Information:
sp_n_codelvl is a reporting diagnostic and is only one of multiple methods that you can determine the encrypted state of a database.
This reporting issue is not at all related to any problems with the proper transparent processing of encrypted databases. The databases when online or offline remain encrypted on disk at all times. All activity to disk will be encrypted to the databases when written.
This issue has been reported but is rare and under investigation. At this time, there is no timeline for resolution.
If you are experiencing this reporting issue and would like a method to determine the encryption state of an attached database, you can also confirm the encryption state with these other methods as described in this KnowledgeBase article:
KB #240101: Test the encryption state of a SQL database or backup
If you experience this sp_n_codelvl issue prior to a fix having been released, please complete a support request on our support page. We may ask some questions.
Related Topics:
KB #240101: Test the encryption state of a SQL database or backup
KB #240040: Cannot start SQL Server or encrypted database is inaccessible when profile is on a remote machine
KB #240102: Encrypted Databases not accessible