I have only skimmed this topic, so forgive me everybody if I've missed an excellent point (and expecially if it was yours), but ...

What SQL Bill says will work -...

Zach,

You could also try running sp_purge_jobhistory on the job to see if that shakes things up for you.

Cheers,

Chris

GF,

I assume you are looking at the TextData field, correct?  Is the word "exec" really there after the "--"?  When I run traces, the only time I see comments like...

Even DATEDIFF can be hard to use here, since it reports the number of "time boundaries" crossed between two dates.  For example, if a deadline was missed by 1 hour...

Scorpvo,

Could you tell us a couple of things?

1. What version of SQL Server; and
2. Does your join query have an ORDER BY clause?

Thanks,

Chris

Yelena,

I bet you're right about the site owners clarifying the question.  The point of my post was just that, while I had guessed correctly, my guess felt uninformed because of...

Although somebody said that they think this is a trivia question with little real-world applicability, I'd like to mention that this comes up as an issue for us in our...

What is the datatype of the dropped column (nvText)?  I think that DBCC CLEANTABLE is supposed to only work with VARCHAR, TEXT, and NTEXT.

-Chris

I think that this used to be used in Sybase to wake up a sleeping thread - it takes a SPID as an argument.  Whatever it used to do, it...

Harcharan,

I would retract my statement from last night that I should be able to explain what's happening.  I can't.  If I were you, I would follow up on kknudson's idea...

Well, I just did a project where we replaced SQL 7 with SQL 2000, and we did a clean install (onto a new server) and then backed up all the...

Gotcha.  I know I didn't have to know, so thanks for taking time to satisfy my curiosity. 

-Chris

Hi Aidan,

Hoo-rah - glad to help! 

So it was char(0), huh?  You might want to talk to your developers about that one.  Or talk to yourself (in a non-neurotic kind...

Hello Aidan,

First, find the ascii character of the offending character.  Example:

declare @badcharcode int

select @badcharcode = ascii(substring(Notes, 6, 1))

from mytable

where mypk = 1

This example assumes that one instance of the...

Well, your post is a little ... broad ... in its scope, but you don't have to do *anything* to get SQL Server to produce XML query output.  You can...