/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
ALTER DATABASE DB_NAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO -- do stuff GO ALTER DATABASE DB_NAME_NEW SET MULTI_USER -- set back to multi user GO