locked
How to create a new database RRS feed

  • Question

  • I am a complete newbie working with SQL Server 2008 Express on my local Win XP Home SP3 machine. I have an ASP.NET website package that needs its own database. I simply want to create an empty database - let's call it dbase11 - then run the .sql file that auto-runs the creation of all tables in it. Following that, I expect the tables to be created and populated in dbase11. I will then need to configure my ASP.NET website package so that it connects with dbase11 and runs in my IE7 browser.

    I would be most thankful for any assistance offered that can make these steps simple for me.
    Wednesday, July 1, 2009 6:32 PM

Answers

  • You can use the T-SQL command CREATE DATABASE, as described in the Boolks online:

     

    http://msdn.microsoft.com/en-us/library/ms176061.aspx


    Tom https://mvp.support.microsoft.com/profile/Tom.Moreau
    Wednesday, July 1, 2009 7:06 PM
  • For simple database creation you type

    Create Database [DatabaseName]

    The statement above will create database file on installation SQL Server directory
    For Example
    C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

    For complete statement see this link http://msdn.microsoft.com/en-us/library/ms176061.aspx
    Wednesday, July 1, 2009 7:14 PM

All replies

  • You can use the T-SQL command CREATE DATABASE, as described in the Boolks online:

     

    http://msdn.microsoft.com/en-us/library/ms176061.aspx


    Tom https://mvp.support.microsoft.com/profile/Tom.Moreau
    Wednesday, July 1, 2009 7:06 PM
  • I strongly recommend
    >>Read some of the good books on sql server
    >>serach on internet about sql server.
    >> read Books online.

    understand the concept and how it works and after that only work on it.

    my one cent.

    Vin





    Vinay Thakur
    Wednesday, July 1, 2009 7:12 PM
  • For simple database creation you type

    Create Database [DatabaseName]

    The statement above will create database file on installation SQL Server directory
    For Example
    C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

    For complete statement see this link http://msdn.microsoft.com/en-us/library/ms176061.aspx
    Wednesday, July 1, 2009 7:14 PM