You may have to remove user connections (some of them may be dead) for a number of reasons: backup, restore or other maintenance activity. Here are quick ways of doing it:

alter database pubs set offline
go

alter database pubs set emergency
go

alter database pubs set online
go