The idea that people are smarter or more professional because they wear a suit is simply because of history; not so very long ago, everyone dealt with a person wearing...

Yes, it is weird.....!

And not at all, thank you for taking the time to try and help, it's appreciated.

Running sp_help_jobhistory shows it with run_status = 4 - i.e. In-Progress. However, it returns a row above it with all the exact same details (date, time, duration etc) with...

Hi Gianluca, yes I know that, which is why I asked the question "What should I be looking for to find out what is going on?". As in, what...

I got this when I ran it:

Msg 2760, Level 16, State 1, Line 1

The specified schema name "tmp" either does not exist or you do not have permission to use...

I thought the same. So, having been told I had got it wrong, I ran...

It IS a very good question, however as has been already mentioned, options 1 and 4 are identical but choosing option 1 is marked incorrect. Still, I guess...

I would like to say a huge thank you to the question posters, even when they post the wrong answer. For me personally, the QotD is increasing my knowledge...

Welcome back, Steve. Thank you for treating us gently on your return! 😀

Sean

Thanks Gary, good question and nice to expose people to Powershell. I have used Powershell extensively on Sharepoint and it is such a fantastic utility, easy to use...

Thanks Andy, something else learnt. And my Wrox 'Professional Integration Services' book was no help at all!!! 😉

Sean

Thank you, a nice puzzle to work out first thing in the morning. Close, though, I had forgotten that 'COMPUTE' had been deprecated and had to think about that...

Thanks Andy, good question to get the grey matter thinking about security. Personally I really liked the format of the question, it was a great way to add interest...

Personally, I do find I actually get more done when working at home - there are far more distractions in the office than at home, where I can just steam...

Well, maybe I'm nitpicking, but the question says "List all the differences....." and one of the answers (correctly) says they "both enforce uniqueness...." - well, if they BOTH enforce uniqueness,...