Charlie,

You are probably using up the 4000 character space available in the
variable. Here is a minor change to Linchi's script to PRINT each line as
it is created, instead of printing them all at the end. This will give you
pretty much the same output.

RLF


declare @dbid int,
@sql varchar(4000),
@name sysname,
@old_name sysname,
@filename nchar(260);

declare db_cr cursor
for select dbid, filename
from master..sysaltfiles
where dbid > 4
order by dbid;

open db_cr;

set @sql = '';
set @old_name = '';

fetch next from db_cr into @dbid, @filename;
while @@fetch_status = 0
begin
If @old_name <> db_name(@dbid)
select @sql = @sql + char(13) + char(10) +
'EXEC sp_attach_db N''' + rtrim(db_name(@dbid)) + ''',
N''' + rtrim(@filename) + '''';
else
select @sql = @sql + ', N''' + rtrim(@filename) + '''';

select @old_name = db_name(@dbid);
fetch next from db_cr into @dbid, @filename;
-- PRINT OUT every piece separately.
PRINT @sql;
SELECT @sql = ''
-- AND CLEAR the variable
end
close db_cr;
deallocate db_cr;





"Charlie" <Charlie (AT) discussions (DOT) microsoft.com> wrote

That did it!

Thank you both.

"Russell Fields" wrote: