#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    50
    Rep Power
    11

    How to used and configure Sql server 2000


    Hi alll...I kindda new in this whole sql thing...so can all tell what..is sql server and how to configure it...please
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Binghamton, NY
    Posts
    22
    Rep Power
    0
    SQL Server is a database engine. It doesn't need to be configured. Just install it, open the program called Query Analyzer and start writing SQL statements. If you don't know SQL then take a class on it or use Microsoft Access instead.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    2
    Rep Power
    0
    I've downloaded and installed sql2kdesksp3.exe but cannot find the query analyzer program - where is it? do i need to install Visual Studio .NET too? Sorry for such a newbie question.
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Location
    Binghamton, NY
    Posts
    22
    Rep Power
    0
    It should have installed query analyzer and enterprise manager for you. You don't need Visual Studio to use SQL Server. Visual Studio contains programming languages that you could use to create an application to connect to your database if you so desire. I know shelling out $50 for a book is tough, but it would make this experience much less frustrating.

    Another option is MySQL (database) and PHP (programming lanquage). These are both free and there is a lot of free online help for these on the internet. A book isn't really needed to get started with these.

    http://www.mysql.com/
    http://www.php.net/

IMN logo majestic logo threadwatch logo seochat tools logo