Thanks, Allen, for all your help

Since this server is our SMS central site server, I don't know what impact will be if I select a single user mode, can other SMS services be able to...

just ran a select * from sysobjects where ID=258647932 on 'mydb' Web reporting server, came out nothing

Thanks, Allen

just want to be sure, on 1st step of the job to run: ALTER DATABASE mydb WITH IMMEDIATE instead of detach all user

message from SQL logs:

Process ID 52 killed by hostname RLGHNCSXN1E, host process ID 1404.

I look Task manager:

Process ID 1404 is sqlagent.exe

the step failed is 1st one

here is 1st step of the job

declare @spid int

declare @spid2 char(2)

declare curs1 cursor

for

(select spid from sysprocesses where dbid= (select dbid from

sysdatabases where name = 'aexns'))

open curs1

fetch next from curs1...