Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting up user database

Status
Not open for further replies.

cartman1976

Programmer
Mar 23, 2006
2
CA
Hi,

I have a setup package that distributes the mdf and the ldf file.
I have a couple of questions.

Do I have to install the database files into the SQL Server folder or can I install them elsewhere? (When attaching, I can specify the location, correct?)

Also, how can I attach the database during setup?
I use Wise to create teh setup package.

Thanks,
 
Use the sp_attachdb command. Refer to the BOL for the syntax. And you will be able to tell it where the files are located.

-SQLBill

Posting advice: FAQ481-4875
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top