Hello all,

I have the following error on the Database maintenance plan:

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'IVCAPP2' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'Backup IVCAPP2' on 17-7-2003 0:00:06
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL Server Driver][SQL Server]Database state cannot be changed while other users are using the database 'fieldvision4'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[1] Database fieldvision4: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.

The following errors were found:

[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **

[2] Database fieldvision4: Transaction Log Backup...

The backup was not performed since data verification errors were found.

Deleting old text reports... 0 file(s) deleted.

End of maintenance plan 'Backup IVCAPP2' on 17-7-2003 0:00:06
SQLMAINT.EXE Process Exit Code: 1 (Failed)


There are two applications that will use the database but they connect using SA as ODBC/UDL connection account.
I checked the authorisation and found out that the SQL server was started by a local/user and changed that to the system account (witch I tested in the office and there it worked) with the DB owner set to SA and the owner of the Job being SA, this should solve the problem.

But the error message tells otherwise.

Can somebody give me a hint, I don't know where to look anymore.


Thanks in advance, Paul