Problems Creating Database On SQL Srvr. 2005 Ent. Edtn.

Posted - 12/17/2006 : 07:23:22



Hi,

I have just started to learn SQL Server 2005, and am currently using the MCTS SQL Server 2005 Self-Paced Training Kit. I am literally at the very start, and already seem to have hit a snag and can't figure it out. From browsing here in the past I recall people here seemed quite clued up, and I was hoping someone might be able to assist.

I am using SQL Server 2005 Ent. Edtn. (trial) on Win XP Pro (SP2). I am basically trying to run a sample script copied from book to create a database and primary, secondary and log files. Whilst I have the theory down, and thought I understood the SQL (have used other DBMSs in the past, MySQL/ACCESS etc.) I am getting an error when trying to run the following code when connected to the default instance on my PC. The code I am trying to run is:


create database Sales

ON

primary

(name = SalesPrimary,

filename = E:Sales_DataSalesPrimary.mdf,

size = 50mb,

MAXSIZE = 200,

filegrowth = 20),

Filegroup SalesFG

( name = SalesData1,

filename = F:Sales_DataSalesData1.ndf,

size = 200mb,

maxsize = 800,

filegrowth = 100),

( name = SalesData2,

Filename = F:Sales_DataSalesData2.ndf,

Size = 400mb,

Maxsize = 1200,

Filegrowth = 300),

Filegroup SalesHistoryFG

( name = SalesHistory1,

filename = F:Sales_DataSalesHistory1.ndf,

size = 100mb,

maxsize = 500,

filegrowth = 50)

LOG ON

(name = Archlog1,

Filename = G:Sales_DataSalesLog.ldf,

size = 300mb,

maxsize = 800,

filegrowth = 100)

I find I get the following error message:

Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'E'.
Msg 132, Level 15, State 1, Line 16
The label 'F' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 22
The label 'F' has already been declared. Label names must be unique within a query batch or stored procedure.

Anyone have any ideas? Your help is greatly appreciated!

Thanks,

Will