It's backing up to a local disk on the machine, and there never seem to be any other I/O errors--it's just while backing up. I've just learned it's probably a...

I take issue with that statement--you can have fun programming in raw assembly language if you find the subject of the program...

I think the compatibility thing is a red herring--the STOPLIST keyword wasn't introduced until SQL 2008, so presumably one of the things that a database in compatibility mode 90 has...

I read the word "hardened" and still got it wrong, probably because "hardened" is such a nebulous term--I had no idea what it meant with relation to SQL server. (Is...

Technically, I've never been fired, but neither have I left any job of my own volition--in every case so far I've lost my job due to being made redundant. In...

Seems I should clarify: I said it wasn't a totally unreasonable position, not that it was a position I agreed with. Wanting cross-compatibility between different database platforms is something that...

You need to tell SQLCMD which server to connect to in order to run the script you're passing it--you do that with the -S parameter (note that's a capital S,...

One of those where I had no clue as to the answer so picked a random one to see what the real answer was--therefore I learned something today, which is...

Well, it's not a totally unreasonable position, so long as you actually know what you're talking about...

Do you have the .NET Framework version 4 installed? That looks to be what it's looking for (although I would have expected it to complain about the missing framework earlier...

I don't think you can do that, can you? 'sa' is a special login which isn't allowed to...

snitnik (3/19/2014)

---

This question is messed up.

Option one:

The distributor needs to be the same version as the publisher

This statement is clearly wrong, as they don't have to be of the same...

GilaMonster (3/17/2014)

---

I just love the way a couple of heavy IO operations turns my (5 month old) laptop into a paperweight. Busy shrinking one DB and zipping the backup of...

I've had people who should know better...

Are you sure the 2008 Management Studio isn't still on there? I have 2008 R2 and 2012 installed on this machine, and the Management Studios for both are still available.