I should agree that temp tables and cursors are not the most elegant constructs, but this is exactly like it used to be with the goto operator in many languages...

According to BOL you can do pretty much whatever you want from the command line using scm utility, create service, start it, pause, stop, and restart.  And pausing the server...

#1, of course, #3 being the second choice, both are about the actual creation of the software, however your choices with #3 are limited by somebody who is doing #1

After looking at the explanation I think by "A and C" they meant ASP

Now, how stupid is that?  Not only this answer is as arbitrary as the normalization rules themselves, but who the heck is Michael F. Nicewarner to...

I should agree that this is a pretty good question, and yes, it is formatting.  "MIDDLE" simply works as an alias.  Also, all the usual table specifications work too.  Try...

Yeah, wouldn't it be nice if whoever posted this question tried to have at least the same query in the question and the answer?  pretty sloppy, if you ask me...

Actually, I kind of liked the question, well, not right away, of course...  But then, when there was no error after putting USE PUBS first, and SET FMTONLY next, I...

Same here...  The question is pretty weird, since it basically is an undocumented command that changes from SP to SP, but the answers are even worse...

I would agree that the answer should have been "none of the above".  IMHO, the one that is shown as the correct one has nothing to do with the CASCADE...

Getting the same error when DTSing text to text, and yes, moving the longest input line to the top did help, however that does not seem to be a viable...