DBCC CHECKDB ('ufdata_001_2012')--DBCC CHECKDB ('ufdata_202_2012', REPAIR_REBUILD)Use mastergosp_dboption 'ufdata_001_2012', single, true--更改成单用户 alter database test set single_user with rollback immediate --with rollback immediate执行这个命令之后,SQL Server立即断开所有的连接并回退它们的事务。所有正在执行事务 Read More
posted @ 2012-12-05 14:25 银杏叶儿 Views(142) Comments(0) Diggs(0) Edit