How about this? Less lines

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

+ 'EXEC master.dbo.sp_detach_db @dbname =...

boumerlin,

I have the same issue as you stated in this thread. The difference is that I want to drop all of these "orphaned" users that exist in AD, but still...

Thanks much. This will be required reading for my Jr. DBAs.