Build Your Own ASP.NET 2.0 Web Site Using C# & VB, Second Edition

Figure 7.3. Exploring the Dorknozzle database

Once you click Yes, the new database will be created, and a link to it will be added

to the Data Connections node in Database Explorer. You can expand it to view

its contents, as Figure 7.3 illustrates.

Creating a New Database Using SQL Server

Management Studio

To start SQL Server Management Studio, which we learned to install in Chapter 1,

select Start > All Programs > Microsoft SQL Server > SQL Server Management Studio

Express. In the dialog that appears, enter localhost\SqlExpress into the Server

Name box, and leave Authentication mode to Windows Authentication, as Figure 7.4

illustrates.

After you connect to SQL Server, expand the Databases node to see the current

databases. If you’ve just installed SQL Server, you’ll only have installed the system

databases, which are grouped under a System Databases node. In Figure 7.5 below,

you can see that I have another database, named BalloonShop, on my SQL

Server.

256

Chapter 7: Database Design and Development

Figure 7.4. Connecting to a SQL Server instance

Figure 7.5. Inspecting your SQL server instance

To create a new database, right-click the Databases node, and select New Data-

base… from the context menu. In the dialog that appears, enter Dorknozzle into

the Database name field, then click OK.

Congratulations, you have a brand new database to play with!

257

Creating a New Database Using SQL Server Management Studio