DBO OFF Script

-- DBO OFF Script help DBA put all or some database out of DBO mode after 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 MULTI_USER WITH ROLLBACK IMMEDIATE' 
+ @vbcrlf + 'GO' + @vbcrlf +
'ALTER DATABASE ['+ name + '] SET MULTI_USER'
+ @vbcrlf + 'GO' + @vbcrlf
from sys.sysdatabases(nolock) where dbid>4 order by name

Learning SQL