Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 MDF & LDF

Author  Topic 

codruta.crisan
Starting Member

1 Post

Posted - 2004-04-30 : 05:18:33
Hallo,
I have received from a customer just 2 files x.MDF and y.LDF. He is asking me to add this data to the one that I alwready have used in a soft programm.
I've read here that I can use "sp_attach_db" command to create the data on my SQLServer. Can anyone tell me how exactly can I do that? An example would help. Is that all I have to do in order to see the data from my client? And if I want to attach it to the existing one on my software programm, can I do that? How?
Thanks!

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2004-04-30 : 07:04:42
HTH..
EXEC sp_attach_db @dbname = N'ypubs',
@filename1 = N'c:\mssql7\data\pubs.mdf',
@filename2 = N'c:\mssql7\data\pubs_log.ldf'

- Sekar
Go to Top of Page
   

- Advertisement -