it sounds like you want to have a database on a ramdrive where there's one table in it, which has been in another database previously?
if so:
create a database in the sql-manager and put the datafiles onto the ramdrive, then do:
select *
into [new_database]..tablename
from [old_database]..tablename
and voila
|