Got this one right after a lot of reading.. Thanks for a good qotd..

an easy one to start my day...and its a friday!!!!!!!!!! 😀

Great question... learnt something new today..! Thanks for the qotd

Hugo Kornelis (2/13/2013)[/b]

I do not agree with some of the comments here that time zone of the computer was required to answer this. Once I saw that the time portion...

archie flockhart (2/12/2013)

I selected "none of these are correct".

The third is wrong because the requirements are that the three rows for each person are produced with a 1 on the...

Thanks for the reply. I did find the soultion. The allow_inprocess option in the properties dialogue box for the OLEDB provider should be checked. I didn't completely understand for what...

I really wasn't sure if I have to 'GO' or not to 'GO' for my answer...I GOed and got it right..So what I learned from this Qotd is whenever there...

@sestell1

From what I read in BOL, the first time a full text query uses an updated thesaurus file, it automatically loads the thesaurus file.. I have to check...

Thanks for the reply..

Quoted identifier is already on. turning it off is throwing incorrect syntax error. I believe it has something to do with the Oledb provider seetings but what...

All you need to know to answer this question is that parenthesis override any operator precedence. The answer is easily arrived at by finding the odd man out among the...

A great qotd and explanation. Had thunk it many times before getting it right... 🙂

Easy one in a superbowl hangover..Thanx 🙂

If a starter like me can realize the inherent drawback in this question (need dataset), I guess its not a good question for Qotd

Thanks for the reply. I didn't execute the code. I just used the display estimated execution plan.

I checked the messages tab and didnt get the 1 row affected message.

I am...

I am a starter in sql server..

Can some one let me know why i dont get the 1 row(s) affected message as stated but simply

Command(s) completed successfully message..