Creating database (data and Log file) in SQL SERVER 2008 installed location

Thanks for the link!

I was looking at the first method given the link, and it basically
- creates a database in the current instance
- gets the data and log file location of the database
- stores the data and log file location in a variable.

So if I specify as below, it looks like it would automatically pick up the appropriate location for data and log file (i.e., sql server installed location), even if the sql server was installed in E:\.
Can you please confirm?

CREATE DATABASE test;

Select allOpen in new window

In my case, I need to also specify the Size, Maxsize, and Filegrowth, as a part of the create database statement. So I cannot use the plain "Create database test" syntax.
I tried to take out the "FileName" alone from Create database script (as shown below), but looks like "FileName" must be specified, so which means that I need the correct path for data and log file.

For eg, like the one shown below,

BEGIN
CREATE DATABASE [test] ON  PRIMARY 
( NAME = N'TestInstance', SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'TestInstance_log', SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
END
GO 

Select allOpen in new window

So should I first do like what Method 1 in the link does and use that data and log file path to create the actual database?

BEGIN
CREATE DATABASE [test] ON  PRIMARY 
( NAME = N'TestInstance', FILENAME = <@Default_Data_Path from Metod 1> , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'TestInstance_log', FILENAME = <@Default_Log_Path from method 1>, SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
END
GO 

Select allOpen in new window

Just want to confirm that my understanding here is correct and I'm doing the right thing?

Thanks
 

Awesome.
Thanks for the quick reply!