default save location

How can i change the default folder to which my database files are saved? right now it's saving everything to

\program files\mssql server\mssql.1\mssql\data

uggg! i can't even find an option to use a "save as" or export the mdf file. the "save as" tries to save the solution file. Any help is greatly appreciated.

Using SSMS, right-click on the server in Object Explorer, select [Properties], then click on the [Database Settings] tab.

Change the Default Database location in the setting pane.

|||If you want to change the location of the already existing database file, you should consider using the detach / attach functionality which is described in the BOL. Be aware that during this process, the database (not the instance per se) will NOT be available for incoming connections.

Jens K. Suessmeyer.

http://www.sqlserver2005.de