Single user multi user mode issue

http://www.sqlservercentral.com/Forums/Topic672411-149-1.aspx

use master
go
declare @kill_spid varchar(20)
-- Find spid of user connection to database test
select @kill_spid= max(spid) from master.dbo.sysprocesses
where dbid in ( select dbid from sysdatabases where name = 'test' )

select [Connection to Kill] = @kill_spid

-- Kill connection to db test
exec ('kill '+@kill_spid )
go
-- set DB test ofline
alter database [test] set offline with rollback immediate
go
-- Bring DB test online in multi user mode
alter database [test] set online, multi_user with rollback immediate
go
use [test]
select Current_DB = db_name()
go