True, but that won't cause no rows to be inserted, it''l stop the table creation in the first place...

However for all you UK based DBAs out there, in the UK it uses the Airy 1830 ellipsoid, which is not included in any of the options, and the question...

Got me... I didn't read the question properly. Very good 😛

Check out the following article:

http://www.sqlservercentral.com/articles/storingandretrievingbinarydatainsqlserver/359/

Well James, your position sounds prety perfect to me. In fact if you want a replacement I'd be only too happy to step in (20 years working with a variety...

It works fine, I've got servers at home running 2000, 2005 and 2008 instances side by side with no issues.

They need to be installed in the right order though,...

Talk about quick to judge... One typo'd question and the...

WOW,:w00t: I got a point back. Thanks Steve 😀

I appreciate it's your morning there and there may be more pressing concerns than a point for a QOD answer.

I think the issue here is the typo in the answers. That fooled me, so after getting it wrong I ran the code and got the same result set as...

Hmmm...

Caught me out, I always thought the resource database was called mssqlsystemresource. That's the name I would have expected to see in the question.

Congrats on a tricky question 😉

Doesn't the "Hybrid approach of one or more of the above" answer in fact cover the above answers? I know it was a multiple select, but having one answer that...

Sense of humour, anyone?

Excellent question. Fooled me, but then it's fooled 82% of us so far...:P

Hi MJ,

Sorry for the massive delay getting back to you, but things went a bit mad here for a while. Anyhooo, in answer to your question here's the output:

DBName ...

As one of the ones who got it "wrong" with the right answer, then I'm posting this just to claim my point too 😛