SitePoint Sponsor

User Tag List

Results 1 to 9 of 9

Thread: MSSQL SP3a

  1. #1
    Non-Member XX7509's Avatar
    Join Date
    Feb 2003
    Location
    Antarctica
    Posts
    568
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MSSQL SP3a

    Hi.

    I've got two different questions. If someone has a second.

    1.
    I'm downloading the trial version of MSSQL right now, so I can get the database manager. I was told that the tools wont expire so I can continue to use them to develop databases for my applications, and I don't need to purchse the entire SQL. So I was wondering what the differece is, between the Trial download, and the Developer Edition which costs $40.00, I believe. I just want to make the database, and then install them on other WPP/ISP servers for my web apps. So I dont think I'm going to need a license myself.

    2.
    Will I need to dl and install the SP3a for the trial version? The site said something about "If you dont need the new features included in SP3a you dont need to dl it" but I wanted to make sure, I don't need another worm on my computer because I faild to patch something correctly. I'm asking because I only have dial up, and that SP3a is pretty darn big. I'm using an accellerator go snatch the trial version, otherwise it would take me months to dl the entire 270mb with 56.6

  2. #2
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1.
    120-day Trial Software == 120-day Trial Software
    120 days
    Trial



    2.
    "SP3a includes patches for known vulnerabilities..."

  3. #3
    Wanna-be Apple nut silver trophy M. Johansson's Avatar
    Join Date
    Sep 2000
    Location
    Halmstad, Sweden
    Posts
    7,400
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    If you don't have SP3a, you will pretty much immideatly be infected by the Slammer worm if your SQL server sticks it's head outside the firewall.

    SQL server consists of two parts, namely the Tools and the Server itself. The tools does not expire, but the server does. The server in the developer editition don't.

    The Tools can be used to manage the free, "lite" version of SQL server, MSDE. MSDE is included in SP6, which is why you want the tools.
    Mattias Johansson
    Short, Swedish, Web Developer

    Buttons and Dog Tags with your custom design:
    FatStatement.com

  4. #4
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by M. Johansson
    ...MSDE is included in SP6...
    SP6?

  5. #5
    Wanna-be Apple nut silver trophy M. Johansson's Avatar
    Join Date
    Sep 2000
    Location
    Halmstad, Sweden
    Posts
    7,400
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I mean SP3.
    Mattias Johansson
    Short, Swedish, Web Developer

    Buttons and Dog Tags with your custom design:
    FatStatement.com

  6. #6
    Non-Member XX7509's Avatar
    Join Date
    Feb 2003
    Location
    Antarctica
    Posts
    568
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, I've downloaded MSDE before, but I've always used Access 2003 for the "manager". So basically it's the same MSDE but with better tools?

    About the server "developer edition" will I need that to test the database on my computer ? or will the MSDE/IIS allow me to do that ? I want to create the databases and then test them on my computer, then upload the databases (or detach what ever it's called lol) to another server, but most likely an ISP server or something. I dont have any servers besids the IIS

  7. #7
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MSDE should be enough for testing (== testing functionality, not stress testing etc)

  8. #8
    Wanna-be Apple nut silver trophy M. Johansson's Avatar
    Join Date
    Sep 2000
    Location
    Halmstad, Sweden
    Posts
    7,400
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    MSDE will allow you to do that.
    Mattias Johansson
    Short, Swedish, Web Developer

    Buttons and Dog Tags with your custom design:
    FatStatement.com

  9. #9
    Non-Member XX7509's Avatar
    Join Date
    Feb 2003
    Location
    Antarctica
    Posts
    568
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    GREAT! Thanks! All I need it for is to test the functions, and make sure everything is up and running, and works the way it should.

    (lol, I'm still downloading the SQL Trail. It's been downloading since last night. . .. argh, darn dial up. But I'm using a program with resume so it's all good.)

    O! I remember taking a look at the SP3a last night and I got a link to three files when I clicked "download" do I need to download and install all three of them ?

    Thanks!


Bookmarks

Posting Permissions

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