Hi Winan,
Try looking up the system sp sp_attach_db in your SQL Server Help.
With MSDE you have an osql.exe in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn directory
Type osql.exe /? for more information.
You can make a connection with the following command osql -E or osql -U
-P
Then you can issue sql commands like exec sp_attach_db.
HTH,
Leo
>Dear the experts ..
>I have installed MSDE on Win98 PC and use ABC.MDF that I got from another Ms. SQL Server (after I detached it) .. then I copied it into C:\Program Files\Microsoft SQL Server\MSSQL\Data on Win98 PC where the MSDE installed.. but how to call it? I tried to use ODBC to create the DSN but still not working? any idea would be greatly appreciated and many thanks in advance
>
>Regards
>Winan