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