MSSQL SP3a

[XX7509]

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

[jofa]

1.
120-day Trial Software == 120-day Trial Software
120 days
Trial



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

[M. Johansson]

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.

[jofa]

...MSDE is included in SP6...

SP6?

[M. Johansson]

I mean SP3.

[XX7509]

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

[jofa]

MSDE should be enough for testing (== testing functionality, not stress testing etc)

[M. Johansson]

MSDE will allow you to do that.

[XX7509]

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!