Script to Detach All User Databases

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

JDeMoss Mr or Mrs. 500 Points: 523 More actions · Answer 1

How about this? Less lines

select 'ALTER DATABASE [' + name + '] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;' + char(10)

+ 'EXEC master.dbo.sp_detach_db @dbname = N''' + name + ''';' + CHAR(10)

from sys.databases Where database_id > 5 and name not in ('distribution') order by name

akhamoshioke Ten Centuries Points: 1110 More actions · Answer 2

Ten Centuries

Points: 1110

June 26, 2014 at 8:45 am

Thanks JDeMoss!

Even better.