>You can set/change default location for new databases in SSMS by going to SQL Server properties, Database Settings.
>You can as well specify DB location when you create it. In SSMS, in New Database dialog on the General tab. In T-SQL, CREATE DATABASE in the ON clause.
Thanks, this is good to know. Next time, I will watch for that at the creation time.