Viewing post 346 (of 346 total)
How about try
select ' RESTORE DATABASE ' + name + ' from ' + name + '_dat'
from sysdatabases
where name not in ( 'model', 'northwind', 'pubs','tempdb')
This will...
September 23, 2003 at 9:13 am
#475443