Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2007
    Posts
    5

    Unanswered: stupid question TIME!

    Hi

    I want to run SQL Server 2000 at home, on my PC. I dont have a server. My OS is Windows XP. Is this possible? Or do I have to use something like Access. If so then that sucks.

    I use SQL Server at work and I want to practice at home.

    please help

    p.s i have Personal ed and standard ed.

    thanks
    Paul

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Why not download SQL Server Express? You'll be upgrading to 2005 eventually, so you might as well get experience on that.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Aug 2007
    Posts
    5
    thanks but will that allow me to create a database without having a server?

    i just have a stand alone desktop pc. running windows xp

    how do you register a server in this case?

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You can run SQL Server Express on a desktop. Also download SQL Server Management Studio Express, and you can create databases/code/whatever.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by blindman
    you can create databases/code/whatever.
    Almost. If you shell out for devloper you get the equivalent of Enterprise just not licensed for distribution. Express is free, developer is $50. Express omits a few features for example sql agent and is throttled too.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Aug 2007
    Posts
    5

    help

    can someone post a straightforward answer please

    i tried to download express

    it asked for .net first(dont know what that is,heard of it, but dont know what it actually is) downloaded that. it isn't on my installed programs list in control panel add remove progs. tried express download again anyway. worked. clicked through the install wizards, seemed to be doing a lot. didnt have a clue what. blah blah blah. tried to run, START, PROGRAMS, MS SQL SERVER 2005, CONFIGURATION TOOLS(WHAT THE HELL??), ONE OF THREE options- SQL CONFIG MANAGER, ERROR AND USAGE REPORTING, SURFACE AREA CONFIG.

    errrrrr.....where's the things I need. i.e Enterprise Manager and Query Analyzer, and books online for reference

    i'm mega confused here

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Well, here is the first part. I have to say, I am unhappy with not being able to make the search page my default home page, but what can you do?

    http://technet.microsoft.com/en-us/s.../bb428874.aspx

  8. #8
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    EM and QA have been replaced by a single beast in 2005, called SQL Server Managment Studio (SSMS). the free version is called SSMS Express. its download is here: http://msdn2.microsoft.com/en-us/express/bb410792.aspx (search for "SQL Server Management Studio Express" on that page).

  9. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    SSMS boo-hiss!
    George
    Home | Blog

  10. #10
    Join Date
    Sep 2007
    Posts
    1
    You could also install a virtual machine on your home PC and load Windows 2000 or 2k3 on it and then SS2000.

Posting Permissions

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