ʹsql server лԭʱܻ
Ϊݿʹã޷öݿĶռȨ





һ취
УMicrosoft SQL Server Management Studio

һݿͼ-->-->ѡ-->״̬-->Ʒ   

Ĭmulti_userûģĳsingle_userûͿˣĵʱһʾ˵

     ҪݿԣSQL Server رմݿӡǷȷʵҪԲر?   


ǾͿˣӦÿԽлԭˣ

ǵûԭ֮Ŷ  single_user Ļ˾ͷʲˣ



ûԣ

Ϊݿʹã޷öݿĶռȨ---ԭɾݿĽ
 
server 2008ݿʱ֣


Ϊݿʹã޷öݿĶռȨս




ؼSQL䣺

ALTER 
DATABASE [datebase] SET OFFLINE WITH ROLLBACK IMMEDIATE


֮

ALTER database  [datebase]   set online


