Location of dbases.

Hi!

When I'm looking at the properties of my dbases I see there are at c:\program files\ms sql server\ etc..

But I want to put ALL my current and future databases to E:\.

Can somebody tell me how to achieve that?

You should use alter Database command to move the files to the new location.

When you create your database you can specfic the location that you want the files create as part of the create Database command.

Michelle

|||

I've found out how to place new databases.

But can't I igive up a default location? Cause people that don't know about it maybe put it in the wrong place.

And the alter command? I tried to change it true the GUI but the location properties where grey.