>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.
Erik Moore
Clientelligence