using sp_dboption I got an error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

using sp_dboption I got an error

When I tried to make the db in single user mode using sp_dboption I got an error.How to rectify this and make the db to single user
USE master
EXEC sp_dboption ‘userdb’, ‘single user’, ‘true’ Server: Msg 5070, Level 16, State 2, Line 1
Database state cannot be changed while other users are using the database ‘userdb’
Server: Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
sp_dboption command failed.
kick all the users out first, either by asking them politely to disconnect, or by force, using the kill command.
Tom Pullen
DBA, Oxfam GB
]]>