Viewing 15 posts - 76 through 90 (of 267 total)
Zach,
You could also try running sp_purge_jobhistory on the job to see if that shakes things up for you.
Cheers,
Chris
September 7, 2004 at 5:45 pm
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...
September 7, 2004 at 5:42 pm
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...
September 7, 2004 at 5:31 pm
Scorpvo,
Could you tell us a couple of things?
Thanks,
Chris
September 7, 2004 at 5:07 pm
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...
September 7, 2004 at 5:05 pm
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...
September 7, 2004 at 10:44 am
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
August 19, 2004 at 2:53 am
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...
August 17, 2004 at 1:27 pm
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...
August 17, 2004 at 10:55 am
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...
August 17, 2004 at 9:51 am
Gotcha. I know I didn't have to know, so thanks for taking time to satisfy my curiosity.
-Chris
August 17, 2004 at 9:27 am
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...
August 17, 2004 at 7:31 am
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...
August 16, 2004 at 11:41 pm
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...
August 16, 2004 at 11:30 pm
Hi Harcharan,
DBCC SHRINKDATABASE will shrink the database files, not the tables in the database. To do that, SQL Server may move your data around. This is one reason why this...
August 16, 2004 at 11:22 pm
Viewing 15 posts - 76 through 90 (of 267 total)