How to Create Database in SQL Server 2005 Express Edition

[Klauz]

In this tutorial you will learn how to create a Database in SQL Server 2005 Express Edition. The name of the database that we are going to create is “LibSys” which stands for Library System.

Note that I am using SQL Server Management Studio that is bundled with SQL Server 2008 R2. Regardless of version that you are using the environment still looks the same.

Please follow the steps below to create a database.

1. Open SQL Server Management Studio.
   
   
   
   
   
2. Right click “Databases” and click “New Database”.
   
   
   
   
   
3. Type the name of the Database called “LibSys” and change the Path of the database (You can use your own directory). Then click OK.
   
   
   
   
   
   Now you will see “LibSys” under Databases of Object Explorer.
   
   
   
   
   

You have already finished creating the database. Our next topic is “How to Add Table”.

Back to Visual Basic .NET 2008 Tutorial.