... or even easier than that:

raiserror("something to log",0,0) with log

Not ideal cos it clutters the sql and application logs, but very simple and reliable.

Surely the point is that people should do what they enjoy and (hopefully) what they're good at, not be persuaded because of some strange belief that everything should be gender...

Very often logging needs to be done within a transaction and be made available even if the transaction is rolled back. Aren't SB messages rolled back, so in that situation...

Adam Gojdas (12/16/2009)

---

I never really cared for this method using a drop. When one has any auditing of the DDL that takes place this always has the extra drop...

david.wright-948385 (11/30/2009)

---

It wouldn't...

It wouldn't be...

I think this is one for Steve (Jones):

There have been a number of QoDs lately that appear to be designed deliberately to mislead, on the pretext that everyone will...

I'm pretty sure the '^' character is a caret, not a carot 🙂

Lynn Pettis (11/17/2009)

---

Nope, but I got the answer right without reading the discussion or running the code. I guess the force...

Just wondering... did you write the QOD Lynn?

Exactly. So...

Lynn Pettis (11/17/2009)

---

Dietmar Weickert (11/17/2009)

---

... finally trying to argue that the whole thing were for educational purposes is even more cynical. I hope nobody ever had or will have a...

Can the QOD be changed then please? If not to change the answer (which is my preference) then to explain why the answer given is as it is.

Lynn Pettis (11/17/2009)

---

Toreador (11/17/2009)

---

Lynn Pettis (11/17/2009)

---

Yes, getdate() and getutcdate() return different values, just look at what they return when you run them. However both functions return values that are...

Here is Steve Jones article about the QOD

http://www.sqlservercentral.com/articles/SQLServerCentral/62764/

And quoting from the article here is the objective of the QOD

The Question of the Day is just what it's titled: a daily...