Create Database Using Enterprise Manager in SQL Server
In this article I am going to explain how to create database using enterprise manager in SQL Server.
Introduction
In this article I am going to explain how to
create database using enterprise manager in SQL Server. We create database using
CREATE statement in SQL server. To create database using SQL query.
In SQL server we can create database using
Enterprise Manager.
Steps for creating database using Enterprise
Manager
Step 1 : Start SQL server :

Step 2 : Right click on database => now
click on New Database :

Step 3 : Enter name of database :

Step 4 : Now click on "Options ". Here
you can change recovery model and compatibility level :

Step 5 : Select recovery model. It is
three type Full, Bulked logged and Simple :

Step 6 : Select compatibility level. It
is also three type SQL Server 2000, SQL Server 2005 and SQL Server 2008 :

Step 7 : Now click on "Filegroups" to
change other setting :

Step 8 : Now Click on OK button to
complete the process:

Step 9 : Now EMP_INFO database is
created:
