You first do a sp_detach_db from the original SQLserver, then copy the files
then do sp_attach_db on the new SQLServer system.
Myles.
> -----Original Message-----
> From: Jason Webb [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 13, 2000 2:30 PM
> To: Multiple recipients of list offtopic
> Subject: [DUG-OFFTOPIC]: MSSQL new database
>
> Hi,
>
> Semething simple seems to be so hard to figure out.
>
> I have 2 MSSQL v7 database files user1.mdf and user1.ldf files and I want
> to
> add them to my SQL server. I put them in the SQL data directory but can't
> seem to get SQL server to see the files and show them in the database
> list.
> even after a refresh.
>
> Does anyone knoe how to get MSSQL server to see the database and include
> it
> in the list?
>
> thanks for any help
>
> Jason Webb
>
> --------------------------------------------------------------------------
> -
> New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
