GENERATE SCRIPT TO MAKE ALL USER DATABASES OFFLINE.
SELECT ‘ALTER DATABASE [‘+name+’] SET OFFLINE WITH NO_WAIT’+CHAR(10)+’ GO’ FROM
MASTER.sys.databases
WHERE name NOT IN (‘master’,’tempdb’,’model’,’msdb’,’distribution’)
SELECT ‘ALTER DATABASE [‘+name+’] SET OFFLINE WITH NO_WAIT’+CHAR(10)+’ GO’ FROM
MASTER.sys.databases
WHERE name NOT IN (‘master’,’tempdb’,’model’,’msdb’,’distribution’)