Submitted by Stacie_Ray on

You must be logged in and have a current support plan to view the full content of this page.

Click to login »
Symptom

Attempting to disable database encryption results in error ‘NpsSMOError ExecuteNonQuery failed for Database ‘NpsSqlsys’. An exception occurred while executing a Transact-SQL statement or batch. The operation failed because an index or statistics with the name ‘idx_tblPREE_sSSN already exists’. It also puts the database in single user mode, preventing other users from subsequently logging back in

Product Line