Morgan,

If you have SQL2k then you can use EM.

1. start Em
2. right click with the mouse on the server instance you need to change the
default.
3. select the tab labeled 'Database Setting', at the bottom you will see
'New Database default Setting' for data and log.

I hope this helps.

Jorge

-----Original Message-----
From: Morgan.[Email Address Removed] [mailto:Morgan.[Email Address Removed] Tuesday, June 11, 2002 11:51 AM
To: Chris Kempster
Cc: SQLDBA (E-mail)
Subject: Model Database



Would anyone know how to modify the model database so the default path for
the data file is D:\ and the default path for the transaction log it E:\

help much apprecitated.

thanks
Morgan





---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] mail is to be used for Bank business purposes only. Confidential
information should not be sent via email as there is no expectation of
privacy or integrity of the message through the internet.


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This email message has been scanned for the presence of
computer viruses.

Chevy Chase Bank
**********************************************************************
MS Sql Server LazyDBA home page