Attach Database

[DSTEMPEL]

I received SQL7 Database (name "CLIENTS" with 39 tables in it) and have to ATTACH it to existing SQL server. This Database is new for my SQL server (I didn't dettach it).

If anybody knows how to do this?

 

[tlbroadbent]

Check the following topics in SQL BOL.

sp_attach_db

http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp

How to attach and detach a database (Enterprise Manager)

http://msdn.microsoft.com/library/en-us/howtosql/ht_7_design_4wq1.asp

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.