The first sentence of the explanation of why I got the question wrong for saying the answer is no is:

"SQL Server 2005 Express Edition does not listen on the...

The more I read about it, the more I'm suprised it works too.

That's a bit annoying. It will probably be cheaper to use DoubleTake than Mirroring, which...

Why so dead-set on getting a DBA job?

There are plenty of other IT jobs I'm sure you could do. Who knows, there may even be jobs that you...

Grant Fritchey (3/19/2008)

---

Hey, I lead a pack of Cub Scouts. I'm responsible for teaching them the "Fart Song."

[to the tune "The Yellow Rose of Texas"]

Oh, my body has a...

Just out of curiosity, what are you using to send the e-mail?

That button is disabled on mine also. I never realized that was ever a feature in 2000.

But to me it seems just as easy to just UNC to the...

Another thing to consider is how easy your task is to read/modify later.

For off-hours tasks, I'll take a slow-running cursor that is easy to read over a lightning fast solution...

Thanks.

Does it matter that it's a SQL 2000 database I'm restoring...

Because the WAN isn't reliable enough.

Hadn't thought of that. Will that work well when we have occassional network outages here and there?

I'm not sure there are many cases where it is right, but I suppose there are some when they are not wrong 🙂

I occasionally will use them just for simplicity...

Are you sure you didn't accidentally install a named SQL 2005 instance or something instead of upgrading?

We need each office every day because our website and some corporate reports need fresh data. Having it for disaster recovery/redundancy is only part of the need.

Will something like this work?

SELECT

l.bestellnr,

l.lfsnr,

l.ziel,

l.lfs_refnr,

l.lfsGuid,

CONVERT(NUMERIC(9, 3), l.werksmassFM) AS werksmassFM,

ls.lmenge,

ls.pguid_ref,

p.punktName,

p.holzart,

CONVERT(NUMERIC(9, 2), p.laenge) AS laenge,

CONVERT(NUMERIC(9, 2), p.p_transpreis) AS p_transpreis,

(

(

SELECT...

Not being a LiteSpeed guru I hesitate to suggest much. I'd look on Quest's support page. It may be a common problem with a simple solution.

Another thing you...