Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
| |
E-mail
Sign InPick a theme: BlogXP business calmBlue Candid Blue dasBlog dasblogger dasblueblog dasEmerald DirectionalRedux Discreet Blog Blue Elegante essence Just Html MadsSimple Mobile Mono Movable Radio Blue Movable Radio Heat nautica022 orangeCream Portal Project84 Project84Grass Slate Sound Waves Tricoleur useit.com Voidclass2
use masterALTER DATABASE <database>SET SINGLE_USER WITH ROLLBACK IMMEDIATE
-- do work here
use master ALTER DATABASE <database> SET MULTI_USER WITH ROLLBACK IMMEDIATE;