Hi When I try to put the database in single user mode using this command: alter database mydatabase set SINGLE_USER with rollback immediate I am getting this erro message : Server: Msg 5061, Level 16, State 1, Line 16 ALTER DATABASE failed because a lock could not be placed on database 'mydatabase'. Try again later. Server: Msg 5069, Level 16, State 1, Line 16 ALTER DATABASE statement failed. ---------------- also when i issue select * from sysprocesses where dbid = id_of_my_database, I get 0 rows. Aren't these conflicting restults?? Can anyone suggest me a way out?? Thanks.