Sunday, August 17, 2014

Database Creation using SQL Sever Management Studio (SSMS)

In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command. In this article, I am going to explain the steps of creation a database using SQL Sever Management Studio (SSMS) using SQL Server 2008 R2. These below database creation steps will be same for SQLServer 2005 and onward.

Step 1:- Open the SQL Sever Management Studio. For this we have to follow the following path:-

START --> All Programs --> Microsoft SQL Server 2008R2 --> Click on SQL Sever Management Studio (SSMS) --> Open the SQL Server Management Studio using Login information (Username & password or Window authentication )

Please note:- Above path can be changed depending on the Window version.

Step2:- Once SQL Sever Management Studio is opened, opened the Object Explorer. By default, it will be already opened. If it is not opened, then follow the below steps to open it.

Click on the View(Top menu) --> Click on Object Explorer

Once Object Explorer is opened, select the Databases node and right click on it . Then Select the open "New Database...".(as shown in the below figure)


Create database - Select database node
Create database fig-1
Step 3:- On the click of New Database option, New Database window is opened. In this window, we need to provide the database name and let the other values as default.(As shown in the below figure). Since we are creating the database Company_DB, we specify the name Company_DB as the Database name.


Create database fig-2
Specify database name

In this window, we can choose the owner of the database, Path, Initial size, File growth, maximum size for the Data file and the Log file. In this article, let them as default. 



Step 4:- In the "New Database" window, click on the left hand side Options link. It will open the below screen.

Create database Fig-3
Choose collation
In this screen, we can choose the database collation, Recovery Model and Compatibility level. Also there are many other options under the heading Other options, which we can change according to our need. But for creating a simple database, we can let these options has the default values.

Collation is required if we need to stored the data in the languages other than English. Many times we need to store the data of a country in its own language in to the database. For storing the data in different languages, we need to set the collation of the database as shown in the below figure:-

Create database Fig-4
Choose Collation
After that, Click on the OK button below to complete the database creation process. You can see the newly created database Company_DB under the main node Databases.



No comments:

Post a Comment