Viewing 15 posts - 5,506 through 5,520 (of 9,643 total)
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...
April 1, 2009 at 7:01 am
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...
April 1, 2009 at 6:55 am
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...
April 1, 2009 at 6:52 am
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...
March 31, 2009 at 2:16 pm
GSquared (3/31/2009)
Jack Corbett (3/31/2009)
Steve Jones - Editor (3/30/2009)
Overhearing something isn't harassment. If they say something,...
March 31, 2009 at 1:46 pm
Steve Jones - Editor (3/30/2009)
Overhearing something isn't harassment. If they say something, like that offends...
March 31, 2009 at 1:32 pm
SA (3/31/2009)
Jack,I've not explored signed modules yet. However, I've used the above method extensively for providing production support access to Production jobs etc.
I want you to know I wasn't being...
March 31, 2009 at 1:10 pm
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.
March 31, 2009 at 10:33 am
SA (3/31/2009)
It worked...
March 31, 2009 at 10:23 am
I'm really surprised that there hasn't been more action on this thread as everyone has an opinion on this stuff.
March 31, 2009 at 9:55 am
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...
March 31, 2009 at 8:45 am
Jason Crider (3/31/2009)
All applications run under a SQL Login user. This user generally runs only SP's but there may be some legacy items that use ad hoc.
I'd recommend running a...
March 31, 2009 at 8:37 am
Change the font size for the legend?
March 31, 2009 at 8:15 am
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...
March 31, 2009 at 8:13 am
Viewing 15 posts - 5,506 through 5,520 (of 9,643 total)