SQL Server set DB into Single or Multi User mode.
ALTER DATABASE DB_Name_Here
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Or Multi_USER
SET Multi_USER WITH ROLLBACK IMMEDIATE
Or Multi_USER
SET Multi_USER WITH ROLLBACK IMMEDIATE
I have been a SQL Server DBA for 25 years. These are some odds & ends that I have found useful. You can reach me at Barry.OConnell@Yahoo.com
0 Comments:
Post a Comment
<< Home