Try this from query analyzer.



EXEC sp_attach_db @dbname = N'Intergrated',
@filename1 = N'c:\mssql7\data\MARAS1_Data.MDF',
@filename2 = N'c:\mssql7\data\MARAS1_Log.LDF'


'****************

NB:
Intergrated : Name of the database
MARAS1_Data.MDF : The database file (The full path)
MARAS1_Log.LDF : The Log File (The full path)


Good Luck

Sammy Msafiri
System Analyst
Somak Travels


____________________________________________________________________
- This email and any files transmitted with it are confidential and
intended solely for the use of the addressee. If you have received
this email in error you may not disclose, copy, distribute or act
upon its contents without the authors prior written consent. Please
can you notify the system manager at [Email address protected]
immediately and delete this email.
- Any views or opinions expressed are those of the author and do not
necessarily represent those of Somak Travel Limited, Kenya.
- This footnote also confirms that this email message has been swept
for the presence of computer viruses. No responsibility can be
accepted in the event that a virus is contained within it or any
attachments.
- SOMAK TRAVEL LTD - KENYA
NAIROBI, PO BOX 48495. Tel: +(25420) 557832 Fax:+(25420) 535175
MOMBASA, PO BOX 90738. Tel: +(25441)5486197 Fax:+(25441)5487324

____________________________________________________________________

MS Sql Server LazyDBA home page