Post reply

Error code "1 - Error" in SQL Profiler Trace

  • January 29, 2008 at 2:41 pm

    #186022

    Hello,

    I added the Error data column in a SQL 2005 Profiler trace. I used the T-SQL Duration template. Most of the trace entries have the value '0 - OK' but a few have the value '1 - Error'.

    Does anyone know what that error means?

    Thanks for any help!

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • January 29, 2008 at 11:27 pm

    #773123

    Please don't post the same question multiple times.

    http://www.sqlservercentral.com/Forums/Topic449095-149-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 30, 2008 at 7:19 am

    #773272

    Sorry, it was a mistake because the site was running slowly, so I clicked the submit button twice. (I won't do that again.)

    However, I tried to delete the extra post and it was not deleted. Is that a bug?

    I'd also appreciate any help on the question I posted, if anyone has any information on it.

    Thanks,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply