Can I install the db In a different location rather than default?

Hi,

When creating a new database I would like this db to be created on my D drive rather than the default place.How do you do this in sql server 2005 ? I could not find a dialog box or something similar to point to a folder for the data and log file.

Any suggestions?

Hi,

scroll abit right on the datafiles grid, you will find the Path column there.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks !

I feel so silly now ,In sql 2000 is right in front of you .I totally missed the scrollbar.

Thanks

|||

Good that this helped, could you please mark the post as solved then ?

Jens Suessmeyer.

http://www.sqlserver2005.de