Consider the following scenario:
- You have an instance of Microsoft SQL Server in which the user and temp databases are encrypted.
- You turn off encryption on the user databases by running the ALTER DATABASE database_name SET ENCRYPTION OFF Transact-SQL command.
- You restart SQL Server.
In this scenario, you find that the value in the sys.databases.is_encrypted column in the sys.databases dynamic management view is still 1. This is true even though all other databases in this instance of SQL Server are no longer encrypted.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.