How to Create Database in SQL Server 2005 Express Edition

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. SQL Server Management Studio

  3. Right click “Databases” and click “New Database”.
  4. Create New Database

  5. Type the name of the Database called “LibSys” and change the Path of the database (You can use your own directory). Then click OK.
  6. Create New Database

    Now you will see “LibSys” under Databases of Object Explorer.

    Object Explorer

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

Back to Visual Basic .NET 2008 Tutorial.

Comments

Submitted byAnonymous (not verified)on Tue, 11/30/2010 - 21:53

I Had Gone through this same but i got error whn i click OK as.. TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Create failed for Database 'spark'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Please Help me out and reply at [email protected] [email protected]
Submitted byAnonymous (not verified)on Thu, 01/27/2011 - 15:54

---------------------------------------------------------------- i do it well
Submitted byhammad (not verified)on Fri, 04/20/2012 - 00:36

please give me library mnagement system database in sql 2005
Submitted byAnonymous (not verified)on Mon, 03/18/2013 - 16:45

i got the same error as above.. while i am trying to add Libsys .. how to overcome this problem..??? plz help me...
Submitted byAnonymous (not verified)on Mon, 03/18/2013 - 16:55

hey all,, i solved the problem using google.. just open the studio with administrative privelege!! thanks all
Submitted byAnonymous (not verified)on Thu, 03/28/2013 - 21:20

wow ang galing naman poh kasi drupal ang ginamit mung website maker jejeje... sana matutunan ko din yan kaso mababa ksi yung amount ng RAM memory ko
Submitted byBhavanion Mon, 01/27/2014 - 18:48

TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Create failed for Database 'ex'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Plz suggest some ideas.. [email protected]
Submitted bynamangcon Mon, 03/10/2014 - 15:05

want to know about sql

Add new comment