Popular Posts

  • Retrieving the data posted to a JSP file from HTML file
    Now I will show you how to retrieve the data posted from a HTML file in a JSP page. Consider an html page that prompts the user to enter his...
  • Accessing the Standard CGI Variables
    Accessing the Standard CGI Variables: To build the successful web application, you often need to know a lot about the environment in which ...
  • INTRODUCTION TO C
    INTRODUCTION TO 'C': C is a programming language developed at AT & T's Bell laboratories of USA in 1972.it was designed by d...
  • SQL ALIASES
    SQL aliases can be used with database tables and with database table columns, depending on task you are performing. SQL column aliases are u...
  • Learning about Events (Continue)
    Learning about Events (Continue) Lets program the Form_Load event. "MsgBox" is Visual Basic command that launch a message box. for...
  • Exercise 11.3: Polymorphism
    Steps to follow: 1. Write Person.java as shown below in Code-11.3.a under polypackage directory. (You are welcome to do this work using eit...
  • The Command Button's KeyPress, KeyDown and KeyUp Events
    The Command Button's KeyPress, KeyDown and KeyUp Events The events that will be mentioned in the following pages are commonly used, and ...
  • SQL AVG
    The SQL AVG aggregate function selects the average value for certain table column. Have a look at the SQL AVG syntax: SELECT AVG(Column1) FR...
  • INTERFACES EXAMPLES
    package interfaceexercise; // Define an interface with three abstract methods. // Any class that implements this interface has to // impleme...
  • SQL LIKE
    We will use the Customers table to illustrate the SQL LIKE clause usage: FirstName LastName Email DOB Phone John Smith John.Smith@yaho...

Wednesday, March 18, 2009

how to create a new database using Management Studio

In previous chapters, you learned to how to connect to SQL Server 2005 using management studio. In this chapter, you will learn how to create and delete a database.

Create new database

To create a new database, right click on the "Databases" node in the left panel in the Management studio. You will get couple of options in the context menu. Select the option 'New Database'.




You will get another dialog box where you have to specify few details. The most important one is the database name. In the below screenshot, I have specified the new database name as "MySampleDatabase".



You may notice two other circled fields called "logical name" and "path". When any database is created, there is at least 2 files created in the hard disk. One file is called "Data file" and it has an extension of .MDF. The other file is called "log file" and it has an extension of .LDF by default. The logical names are the internal names used by the SQL Server to represent the data file and logical file. The path represents the physical location of the above files in your hard disk. The default location will be within the Program Files folder. You may change it to your projects folder or any other folder you want. However, the only mandatory entry required fill to create a new database is the database name.
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)