Change of default path while creating New DB

Hi,
while creating new database and setting the Data and Log file by
default it shows the default path (based on SQL Server Installation) .
If we want to change the path we will be able to change. But while creating
Data and Log file i want the the default path it shows to some other default
path.
Please give me the solution as early as possible
Thanks,
Herbert
Hi
Enterprise Manager
Click on the Server
Right click
Select properties
Database Settings Tab
Change the values 2/3 of the way down the page "new database default
location".
From that point onwards, new databases created use those paths.
Regards
Mike
"Herbert" wrote:

> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while creating
> Data and Log file i want the the default path it shows to some other default
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert
|||server propeties->database settings->def. data&log dir?
I think this settings stored somewhere in the registry.
"Herbert" wrote:

> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while creating
> Data and Log file i want the the default path it shows to some other default
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert
|||Hi,
CHange the value for the below registry keys.
For a SQL 2000 default instance, the default folders are stored in the
registry under:
HKEY_LOCAL_MACHINE\SOFTWARE\MiXcrosoft\MSSQLServer \MSSQLServer\DefaultData
HKEY_LOCAL_MACHINE\SOFTWARE\MiXcrosoft\MSSQLServer \MSSQLServer\DefaultLog
For named Instance:
HKEY_LOCAL_MACHINE\SOFTWARE\MiXcrosoft\Microsoft SQL Server\[Instance
Name]\MSSQLServer\DefaultData
HKEY_LOCAL_MACHINE\SOFTWARE\MiXcrosoft\Microsoft SQL Server\[Instance
Name]\MSSQLServer\DefaultLog
Enterprise Manager:-
These can be viewed/changed with Enterprise Manager (server properties -->
database settings). This will also update the registry.
Thanks
Hari
SQL Server MVP
"Herbert" <Herbert@.discussions.microsoft.com> wrote in message
news:95A73C48-62BB-4264-B121-2D3FB8D4E4D7@.microsoft.com...
> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while
> creating
> Data and Log file i want the the default path it shows to some other
> default
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert