If your server/session has ANSI_NULLS ON then any comparison to a NULL value results in Unknown, not true or false. ANSI_NULLS is ON by default in SQL Server so...

What is the problem you are having with Database Mail? No one can tell if there is a fix if we don't know the problem. I use Database...

I agree with jcrawf02. Get sense of humor people! It is April Fool's Day. The scary thing is that I was reading the article as if it...

Quotes from the American Law Encyclopedia Vol 2, Burden of Proof entry which essentially is the "innocent until proven guilty" standard.

In civil cases, the plaintiff is normally charged with the...

GSquared (3/31/2009)

---

Jack Corbett (3/31/2009)

---

Steve Jones - Editor (3/30/2009)

---

The definition is in the ear of the victim/beholder. However they have to let you know.

Overhearing something isn't harassment. If they say something,...

Steve Jones - Editor (3/30/2009)

---

The definition is in the ear of the victim/beholder. However they have to let you know.

Overhearing something isn't harassment. If they say something, like that offends...

I want you to know I wasn't being...

Just a shot in the dark, but I wonder if the DBF is locked by another session. This might explain the intermittent nature of the problem.

SA (3/31/2009)

---

I've done this in the past when developers / users required access to the system tables / procs which required system admin or some other server level privileges.

It worked...

I'm really surprised that there hasn't been more action on this thread as everyone has an opinion on this stuff.

You could use a DDL Trigger that watches and logs activity for several events. Instead of listing them here I'm going to point you to the BOL reference for...

I'd recommend running a...

Thanks Steve. I don't do Analysis Services, so I don't know the TLA's for it. I thought it was something like that, but, I figured I'd ask, just...

Change the font size for the legend?

Grant,

I'm reading it as 600 million rows (627,966,462) from the Full Text Engine.

I'd also be interested in the execution plan from the Coalesce function query.

You might also get better...