Authority：To Solve the login user "limited Single change to multiple ~!

use master
go
declare @s varchar(max)
set @s=''
select @s=@s+'; kill '+rtrim(spid) from master..sysprocesses where dbid=db_id('sower_new')
exec(@s)
go
alter database sower_new set multi_user

 

 

 

last time I change the Authority to "Single " for the SQL2005,

after that ,I can not access or implement or modify or delete   the Database .

It's so depress .

thanks for my friends help  to solve the problem .