This is the command for it:

ALTER DATABASE pubs SET SINGLE_USER

If there are still users, they can use the database for the current session. Of course, you can kill the users' spid-s to force them out.

You can also do this in Enterprise Manager.