How to Create New Database in sql server 2005,2008:

To create new database in sql server 2005,2008 open sql server management studio and follow the steps given below:

Step1:

Right click on database and select New database:

Step2:

A new database creation window will open.In this window enter the database name you want to create  against database name  section.Once database name is done click on add button .You have successfully created your first database .

In next section we will see how to create user for new database and security related settings in new database.