Saturday, September 1, 2012

SQL Server 2005 Management Studio Express New Database Creation

In this post I will tell you how to create a New Database in Microsoft SQL Server 2005 Management Studio Express.

If you need to download SQL Server 2005 Express edition which is free the use the below link:
http://www.microsoft.com/en-us/download/details.aspx?id=21844

If you want to purchase SQL Server 2005 Developer Edition then use below link:



Step 1(SQL Server 2005 Management Studio Express Overview):
Open up Microsoft SQL Server 2005 Management Studio Express from Programs menu. Below I have shown the Overview window of Management Studio Express.




Step 2 (SQL Server Database Creation Option):
When you click on Databases folder then you will get a context menu having New Database option which will be used for creating New Database.


Step 3 (SQL Server New Database Creation Window):
Now we have got New Database Creation Window. Enter the name of the database which you want to create. When you enter the database name then database files gets shown in list box which is highlighted in below screen. Keep the default setting and click OK and your database gets created successfully.


I will highly appreciate your suggestions to make this post better.

No comments:

Post a Comment