Thanks Erik,

Your last item seems just what I was looking for. I'll be looking into that one first.

Cheers,

JimN

>>So, I thought, someone has mentioned the "console" before so I'll go use that. Looking around I found Start-->Microsoft SQL Server 7.0-->MSDTC Administrative Console, clicked on it but got 'shortcut not found' (roughly). It was looking for "dac.exe" in WINNT/System32 but it asn't there nor anywhere else.
>
>If you use SQL Server Developer edition, you can use the query analyzer to execute sp_detach_db. After running this, you can make copies of your database and log files, and copy them to any other MSDE or SQL 7 Server, and then run sp_attach_db to attach it to the new server. The equivalents of sp_attach_db, and sp_detach_db are also available through SQLDMO:
>
>oSvroot = CreateObject("SQLDMO.SQLServer")
>oSvroot.Connect("(local)", "sa", "")
>oSvroot.AttachDB("mydatabase", ;
> "c:\mydetacheddatabase.mdf,c:\mydetacheddatabase.ldf")
>
>
>
>If you only need to copy the structure and not the data, then you can 'Script' the database to a file, and then run that script on the target machine.