Integrity check job fails: sqlmaint.exe SQLSTATE 4200, Error 22029

Integrity check job fails with message sqlmaint.exe [SQLSTATE 4200] [Error 22029]. The step failed.
snilesAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
0
 
snilesAuthor Commented:
Good stuff there.  Following those instructions I found a message: "[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.".

This clearly points to why it's failing and what I have to do.

Thanks so much!
0
All Courses

From novice to tech pro — start learning today.