SET NOCOUNT ON

DECLARE @dbname SYSNAME
DECLARE @filelist varchar(8000)
DECLARE @filecmd varchar(8000)
DECLARE @filecount INT
DECLARE @filenbr INT
DECLARE @fileid SMALLINT
DECLARE @filename NVARCHAR(260)

SELECT name
INTO #databases
FROM master.dbo.sysdatabases
WHERE name not in ('master', 'tempdb', 'model', 'msdb')
ORDER BY name

CREATE TABLE ##files
(
	fileid SMALLINT NOT NULL,
	[filename] NVARCHAR(260) NOT NULL
)

WHILE (SELECT COUNT(*) FROM #databases) <> 0
BEGIN

	SELECT TOP 1 @dbname = [name]
	FROM #databases
	ORDER BY [name]

	SELECT @filecmd = 'INSERT INTO ##files SELECT fileid, rtrim([filename]) FROM ' + 
        @dbname + '.dbo.sysfiles'
	EXEC (@filecmd)

	SELECT @filecount = COUNT(*) FROM ##files

	SET @filenbr = 1

	SELECT @filelist = ''

	WHILE @filenbr <= @filecount
	BEGIN
		SELECT @fileid = fileid, @filename = [filename] FROM ##files ORDER BY fileid DESC

		SELECT @filelist = @filelist + '@filename' + CAST(@filenbr AS VARCHAR(3)) + 
                ' = N''' + @filename + ''''

		IF @filenbr = @filecount --last file, no comma
		BEGIN
			SELECT @filelist = @filelist + CHAR(13) + CHAR(10)
		END
		ELSE
		BEGIN
			SELECT @filelist = @filelist + ',' + CHAR(13) + CHAR(10)
		END

		SELECT @filenbr = @filenbr + 1

		DELETE FROM ##files
		WHERE fileid = @fileid
	
	END

	--print attach statment for current db
	PRINT 'sp_attach_db @dbName = N''' + @dbname + ''',' + CHAR(13) + CHAR(10) + 
        @filelist + 'GO' + CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10)
	
	DELETE FROM #databases
	WHERE name = @dbname
END

DROP TABLE ##files
DROP TABLE #databases