Standard configuration for a SQL Express install does not allow connections from a remote machine. If you need remote connections then you generally need to enable the TCP/IP protocol and...

Bear in mind that's...

I can easily see myself being a blue-collar worker of some kind if I'd been brought up with the same background--my parents weren't exactly rich (although they weren't working class...

The question is a bit ambiguous. It could mean that you grew up in a similar situation and you're asking what you'd have ended up doing 100 years ago, or...

Pity this isn't taking us back 110 years--I could make a fortune by beating Marconi to the punch in creating the first commercial radio systems. 😀

I'm kind of baffled anyone would have picked 29-Apr too--there's actually some logic to picking 31-Mar, but 29th...

I don't think the global economy will *ever* get back to exactly where it was before, which is a good thing--before the crash the whole thing was supporting itself on...

I agree with Lowell. Having two different SQL servers on the same computer are pretty much why named instances exist in the first place, so why can't you use them?

I think there are better ways of determining if someone is a wannabe DBA than with something as simple as a restore command, to be honest, but if it works...

Steve Jones - SSC Editor (10/19/2010)

---

I think there's a little elitist mentality, but someone ought to know how to do this in scripting. It's much more efficient, especially when you...

Wayne's question still applies, though--if the primary box fails, how are you going to fail over to this secondary server if it isn't on the same subnet?

I had a suspicion the answer would be different, so I looked up the Access ROUND() function--didn't realise it did round-to-even before! At school I'm pretty sure we were always...

You're not prefacing the name of your procedure with sp_, are you? That's reserved for system stored procedures.

We monitor all services using Nagios--it has the advantage of being free, but the disadvantage of being primarily for the Linux platform and thus a bit tricky to set up...

Interesting. I've never heard of a partial backup, and am struggling to figure out how it would be useful...will have to do some research!