In this tutorila i will tells you, how to create a database in ms sql 2008.Let's start
Syntax
CREATE DATABASE [DATABASE NAME]
A) Creating a database
Following example creates a database
CREATE DATABASE [ASPXTUTORIAL]
B) Creating a database and locating on different drives
CREATE DATABASE [aspxtutorial] ON PRIMARY
( NAME = N'aspxtutorial', FILENAME = N'D:\database\aspxtutorial.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB )
LOG ON
( NAME = N'aspxtutorial_log', FILENAME = N'E:\database\aspxtutorial_log.ldf' , SIZE = 1024KB , FILEGROWTH = 10%)