Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
keithc
Starting Member
35 Posts |
 Posted - 2004-10-18 : 15:12:48
|
| Receiving a Microsoft ODBC SQL Server Driver Sql ServerRepair statement not processed. Database needs to be in single user mode error message. This is occuring on an machine upgraded from 7 - 2000 Sp3. Please help |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-18 : 16:28:29
|
| Run DBCC CHECKDB on the database that is having the problem. What is the job doing? Is this an integrity check maintenance plan job? If so, please tell us what you have selected in the plan.Tara |
 |
|
|
keithc
Starting Member
35 Posts |
Posted - 2004-10-18 : 17:27:05
|
| Tara yes the job is an integrity check job created from the Maintenance Plan wizard. This is not my install and understand that the wizards can be problematic. I will have Dbcc checkDb run on the Db's. The Job failure Errors as I understand is Specific to Master and MSDB .Finaly,I found an information write into the operating system event log "sql has been using process ID 968 since 9/29/2004 " this did not make sense to me as i didnt think spids went that high. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
keithc
Starting Member
35 Posts |
Posted - 2004-10-19 : 09:58:47
|
| Tara, that was the problem!!! I gather that the job was failing due to SQL not being in single user mode |
|
|
|
|
|
|
DB Jobs failing