Hi Steve,

Great editorial, and some sound advice (both in the editorial and in this thread).

Your error reminded me of an error my former boss made many years ago (back in...

Hi Steve,

>>The quote you mention specifically says "does not raise system errors". I'm not sure where that is direct contradition<<

The contradiction is in "or report errors that are not severe"....

I'm sorry, but the answer is just wrong. Here's an exerpt from the Books Online quote that was linked to in the answer:

Apart from the syntax error (which I missed - shame on me!), there's also insufficient information to assess what the answer would be if the syntax is corrected.

What if Andy doesn't...

Hi wangkhar,

My post was intended only as an FYI, as an addition to the information given in the "official" answer to the post. I didn't intend to criticise the question.

I...

Hi all,

Though Ctrl-Shift-C won't work in Management Studio "out of the box", it IS possible to restore this keyboard shortcut for those who have QA keys preprogrammed in their fingers:

Menu...

I'm surprised at the number of posts claiming that there is just one solution. Below are the four solutions that SQL Server returned on my query. As far as I...

Hi SAM,

I get the same error when I execute on SQL Server 2000. On SQL Server 2005, I do get a response.

However, in all three or four solutions, Kevin uses...

Hi Steve,

Fortunately, I had kept my query window open over the day!

With the clarification that first = leftmost (my first assumption) and the...

Okay, so my assumptions were wrong.

The green office was to the left of the white office." - is that directly to the left (adjacent) or somewhere...

Hi Steve,

Some clues allow more than one interpretation:

"The green office was to the left of the white office." - is that directly to the left (adjacent) or somewhere to the...

Thanks, Steve!

Hi,

I answered D, because I thought that this was a trick question. Turns out it was just a typo.

The correct syntax for EXECUTE AS is: EXECUTE AS USER = 'Bob'...

Hi SQLBill,

True - but it also says:

If the message contains more than 400 characters, only the first 397 will be displayed and an ellipsis will be added...