How to Create Database in SQL Server 2005 Express Edition

Submitted by admin on Monday, October 25, 2010 - 10:06.

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

  2. Right click “Databases” and click “New Database”.

    3. Create 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.

    4. 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.

Tags
sql server
create database

Comments

Submitted by Anonymous (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 by Anonymous (not verified) on Thu, 01/27/2011 - 15:54

---------------------------------------------------------------- i do it well

Submitted by hammad (not verified) on Fri, 04/20/2012 - 00:36

please give me library mnagement system database in sql 2005

Submitted by Anonymous (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 by Anonymous (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 by Anonymous (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 by Bhavani on 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 by namangc on Mon, 03/10/2014 - 15:05

want to know about sql

Add new comment

About text formats