DBO ON Scripts

-- DBO on Script help DBA put all or some database into DBO mode for maintenance or DBA activities.


-- SQL 2000


-- SQL 2005 /2008

DECLARE @vbcrlf varchar(100)
Select @vbcrlf = char(13) + char(10)

select 'USE master' + @vbcrlf +
'GO' + @vbcrlf +
'ALTER DATABASE ['+ name + '] SET SINGLE_USER WITH ROLLBACK IMMEDIATE' 
+ @vbcrlf + 'GO' + @vbcrlf +
'ALTER DATABASE ['+ name + '] SET SINGLE_USER ' 
+ @vbcrlf + 'GO' + @vbcrlf +
'ALTER DATABASE ['+ name + '] SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE'
+ @vbcrlf + 'GO' + @vbcrlf +
'ALTER DATABASE ['+ name + '] SET RESTRICTED_USER'
+ @vbcrlf + 'GO' + @vbcrlf
from sys.sysdatabases(nolock) where dbid>4 order by name

Learning SQL