Forum Replies Created

Viewing 15 posts - 76 through 90 (of 267 total)

  • RE: Last Run Status (Start Date) - Not Updating

    Zach,

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

    Cheers,

    Chris

  • RE: SQL Profiler

    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...

  • RE: Help with SQL- difference between dates\time

    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...

  • RE: Sort order different after DB restore

    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

  • RE: Question of the Day for 07 Sep 2004

    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...

  • RE: Question of the Day for 07 Sep 2004

    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...

  • RE: DB Growth Issue

    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

  • RE: DBCC WAKEUP

    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...

  • RE: DB Growth Issue

    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...

  • RE: SQL 7 --> 2000 upgrade plan recommendation

    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...

  • RE: Locating unrecognized characters

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

    -Chris

  • RE: Locating unrecognized characters

    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...

  • RE: Locating unrecognized characters

    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...

  • RE: XMl in sql

    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...

  • RE: DB Growth Issue

    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...

Viewing 15 posts - 76 through 90 (of 267 total)