Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2009
    Posts
    1

    Red face Unanswered: create database (was "I need help!!!")

    I need to create a database in sql server 2000 for a school registration software for college. Anyone who can help please... kinda worried here.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Code:
    CREATE DATABASE mydatabase
    do you have a specific question?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2009
    Location
    United Kingdom
    Posts
    77
    I would suggest running the code as above , which would create the Data and Log file in the default paths. If you find you don't know how to run this in a tool such as Query Analyzer , you can just do it through Enterprise Manager

  4. #4
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    This is only the beginning. Make sure defaults are set to an area on disk that has space, change the db recovery model to simple if you are not putting jobs in place to manage the transaction logs, etc.

    Have fun !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •