>You can set Server default DB locations thrue SSMS in the Server properties, Database Settings page. For particular new database created in SSMS you can specify location in the New Database dialog, General page. The CREATE DATABASE statement has FILENAME clause for that.
Thanks, and if the database is already created, would there be a setting to move it?