Another day, another new thing learned, thanks!

Michael Lysons (3/13/2012)

---

Koen Verbeeck (3/13/2012)

---

bitbucket-25253 (3/12/2012)

---

What I thought was a nice straigt forward simple question, the results are discouraging...

Great question, nice and straightforward.

Without getting into the detail, comparing against NULL other than using IS or IS NOT mostly results in nothing.

Ah! the disappointment of thinking you've done really well and ticked all the right boxes to then be told you are wrong!... however, faith can then be restored by clicking...

Bugger! Got bored Googling the answer (never done MERGE or INSTEAD OF Triggers before) and thought I'd found it so went for Yes. Only after being told I was wrong...

As most here, pen and paper for me, I tend to try to use a stack of recycled paper (old one-sided printouts no longer required, less so now as we...

Great question for a Monday, thanks Steve.

Hope everybody had a good weekend.

Sometimes when you get the answer wrong, you just know what the conversation will be here.

...and rightly so, the question is setup wrong, but not deliberately so give Steve a...

Another lesson not learned about reading the question and answers carefully.

You can obtain info by querying sys.triggers but they are only stored as objects on the master database. I got...

:ermm:

CoolCodeShare (11/2/2011)

---

call.copse (11/2/2011)

---

Darn, I jumped wrong there, I guess it is because I just didn't think about it. Not really gone for the concept of DDL triggers much yet so...

ipounder (10/28/2011)

---

Good question, however the answer is a bit pedantic, so I'm going to be a bit pedantic in my comment. Whilst you can't disable full text search at the...

Although, like 71% (at this time) of the others, I got this wrong because I was thinking Full-text indexing on a table can be disable/re-enabled. The question, on re-reading, is...

As an example of a bit flip flop it fails on so many levels, but as an example of using case in an update statement it works for me.

Good question,...

I knew we were in trouble with this one when it asked for 3 answers but I could find only 2 that were clearly true.

Went with 2 answers hoping that...

Great question Tom, I can say that as I surprised myself by getting the right answer 😀