Create a sql database

This is a simple sql command to create a database on a sql server. It can be run from the SQL Query Analyzer.

CREATE DATABASE [systeminfo]  ON 
  (NAME = N'systeminfo',
        FILENAME = N'D:\sqldata\MSSQL\Data\Systeminfo.MDF' , 
        SIZE = 6, FILEGROWTH = 10%)
   LOG ON (NAME = N'Systeminfo_log', 
        FILENAME = N'D:\sqldata\MSSQL\Data\Systeminfo.LDF' ,
        SIZE = 1, FILEGROWTH = 10%)
   COLLATE SQL_Latin1_General_CP1_CI_AS
GO