Build a script for CREATE DATABASE/FOR ATTACH

use master
go
Set nocount on

Select 'Use ' + name + char(10) + 'go' + char(10) + 'Set nocount on' + Char(10) + 
'Select ''CREATE DATABASE '' + Rtrim(db_name()) + '' ON'' from master.dbo.sysdatabases where name = Rtrim(db_name())'
+ char(10) + 'Set nocount on' + Char(10) + 'select ''     (FILENAME = '''''' + rtrim(filename) + '''''')'' from sysfiles Where fileid = 1 ' 
+ char(10) + 'Set nocount on' + Char(10) + 'select ''   , (FILENAME = '''''' + rtrim(filename) + '''''')'' from sysfiles Where fileid <> 1 order by fileid' 
+ char(10) + 'Set nocount on' + Char(10) + 'Select ''FOR ATTACH''' + Char(10) + 'Set nocount on' + Char(10) +
'Select ''go'''
+ char(10) + 'go'
  from sysdatabases 
where NOT(name IN ('master','tempdb','model','msdb'))
Order by name