Loading

How to Create Database in SQL Server 2005 Express Edition

Submitted by: 
Visitors have accessed this post 42714 times.


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

i want to know the tables reqired to create asystem for the database
and relations between tables

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]

Me too, I don't know what to do.

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

please give me library mnagement system database in sql 2005

Thanks For provide Oppurtunity....)

i got the same error as above.. while i am trying to add Libsys ..

how to overcome this problem..??? plz help me...

hey all,, i solved the problem using google..
just open the studio with administrative privelege!! thanks all

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

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]

namangc's picture

want to know about sql

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.