What a lot of complainers!

If everybody who had posted came up with a question of their own I bet we'd have some really good questions. And they'd all be...

Darn.

I should know better than to bother with questions where I struggle to read the options!

I don't dare submit a question - I'd hate to be on the receiving end of all these complaints! :w00t:

And besides, the only questions I can think of are ones...

Mine wasn't a complaint - merely an observation.

Sometimes these can actually spark off a really interesting discussion.

I don't, however, have much patience once the same observation has been made over...

Seattle is a long way to go when you're based in the UK.

I don't think the boss would let me come 🙁

Server: Msg 5105, Level 16, State 2, Line 1

Device activation error. The physical file name 'C:\mssql\MYTEST.doc' may be incorrect.

Server: Msg 1802, Level 16, State 1, Line 1

CREATE DATABASE failed. Some...

You're right about people not reading the discussions - they really miss out.

This is a really informative thread (as was yesterday's).

Thank you.

Very interesting, thank you.

I agree absolutely with your statement that if you want something order it, then you should always specify an order by clause.

My belief was that as a consequence of the union removing duplicates, the output always came out ordered. Possibly not if you end up with several worker processes doing...

Nice question

OK, so I've installed Management Studio for 2008 side by side with the SQL 2000 install - so I can still use that on my old server. Out of...

Brilliant - thanks.

In SQL 2000 Query Analyzer it formats the text as if PRINT '7' will happen, and yet it doesn't when you execute it. They must have updated things a...

Nice question.

What a counterintuitive way this behaves!

Maybe we should start having questions phrased - "what is the most interesting answer..."?

😉