Exclusive access to DB

[bob_38]

Hi.

I'm new to this forum so a friendly and polite greet to all..


I get:

Server: Msg 3101, Level 16, State 1, Procedure SP_xxxxxx_TRANS_restore, Line 11
Exclusive access could not be obtained because the database is in use.

..when I try to run an sp that attempts to restore the trans log in SQL2000 and yet I do execute an sp first to drop all spids...can anyone tell me why(maybe)

thanks.



bob.

[skhanal]

There may be an application which reconnects after you kill the connection.

Did you select the database context to master in query analyzer when you run the procedure?

Or after killing the connection use sp_dboption to change database to dbo only and single user mode, then run the procedure.