The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

SQL Server 2005 Express Preview

The real question will be: Can this be a real alternative for people running dynamic websites who don't need all the power and features of SQL Server, yet already rely on things like stored procs that a db like mysql can't provide yet?
(I'm currently reading the site in detail, but thought I'd post this before I'm finished)

i happen to be one of those people who neither (a) owns a sql server license, nor (b) wishes to download the entire 800 gigabyte sql server install file just to pull the QA or DTS apps out of it, which is why i use WinSQL Lite instead of QA

r937, I'm really surprised at your posts this evening... are you an imposter?!

Originally Posted by r937

that MSDE 2000 page says
my point was, DTS doesn't come with MSDE

What bit of DTS do you think MSDE doesn't come with? The DTS design GUI? That's part Enterprise Manager, which is merely the fronted app (similar to how Microsoft Access 2000 is the frontend for JET4 databases)!!

My point is that all the functionality required to *run* DTSes is there, which is all you need on a production server that only needs to support a couple of clients.

But of course if you want to use MSDE as a development platform, then yes, you will have to download EM (as part of the SQL2000 evaluation) in order to actually *create* DTSes.

Originally Posted by r937

just having DTSRUN.EXE in my Program Files folder doesn't do me a whole lotta good

when i double-click it, i get a very brief flash of the DOS command shell window and then it shuts itself down

It's a console application! What do you expect it to do?!

Shell out to the command prompt and run it to see what it outputs (if you haven't supplied command-line parameters then it will probably just spit out the syntax for its parameters)...

Perhaps we're talking at cross-purposes here, because I can't believe that you don't already know this. If that is the case, then you must think me patronising, which is certainly unintentional, but I don't know how else to interpret and answer your comments!

look, i'm sorry, but all i did was try to make a point, and you keep wanting to steer me in other directions

my point was, i don't have anything except MSDE

so in order to run EM or QA or DTS, i need to download something else

last time i looked, it was some humungous 400 meg sql server evaluation install (okay, so 800gigs was an exaggeration)

furthermore, i have heard that after doing so, i would need to know how to pull EM or QA or DTS out of the file or folder or whatever gets downloaded, and given my experiences with microsoft installs, there is no way i'm going down that road, because i absolutely stink at installs

heck, i needed help to install MSDE

repeat: i absolutely stink at installs

please go back to post #2, where i said "too bad it [MSDE] doesn't include DTS"

don't get me wrong, i have used DTS before at work, it runs pretty well (although it's a b1tch to learn), but it's not so great that i would want to wrestle with the sql server evaluation install

Just for the record, installing just the Enterprise Manager (and other GUI tools) is very easy once you have obtained the trial/full version. It's a fully-supported installation option, no jiggery-pokery required.

installing just the Enterprise Manager (and other GUI tools) is very easy once you have obtained the trial/full version. It's a fully-supported installation option, no jiggery-pokery required.

thanks, i shall take your word for it, but shall nevertheless not attempt it

you haven't seen me in action, but if you should ever find yourself in toronto canada, please look me up, i will invite you over to my place, where you can get free beer and in return offer me emotional and technical support as i flounder my way through the install

I'll confirm: after the chunky download, the install is pretty solid for EM. Just a couple of non-tricky options to set and then it's smooth sailing.

I'm still waiting for the GUI they're developing for SQL Server Express. I know there aren't many people dying for this thing, but I am. I never wanted to drop the cash for my own SQL Server license, but MySQL just doesn't cut it for some of the things I'm doing (plus I already have so many nice stored procs written). This is the perfect in between for me, and if they can make a nice or even half-nice interface for it, I'm golden. Saving cash (the extra I pay for shared sql server hosting) and getting what I want

Originally Posted by MarcusJT

10K? Is that all they're paying you?

The rumor is Vinnie's not working for 10k, but 10k worth of twinkies and beer.