Creating a Database in SQL Server ASP.NET

To create database go to start and all programs. Select Microsoft SQL Server. Then select enterprise manager. Expand the Microsoft SQL server nodes followed by the server subgroup. Select local server, and expand the database nodes. Right click on database and new database. A window called database properties will be opened. Now it contains 3 tabs, namely general, data files and transaction log. Just give the database name as products in the text box. Now we can set the location of the database files and growth settings by clicking on the data files.

By default, a new database will be created at this location. We can change this to any location when needed. Using transaction log file tab, it’s used to set location by name or transaction. By default it will be created at the location. Now, click ok to continue. We can see the new database in the name products. When you double click the database it will show you all the available icons in the products database. Now so far in this lesson we have analyzed how to create a new database by using enterprise manager. Up next, we will discuss how to create a database using database wizard.