To Generate Script to Take Multiple Databases O
database #database
select 'alter database ' +name+ ' set offline with rollback immediate' from sys.databases where name not in ('master','model','msdb','tempdb','distribution')select 'alter database ' +name+ ' set offline with rollback immediate' from sys.databases where name not in ('master','model','msdb','tempdb','distribution')