Error 50000

  • crab7

    Mr or Mrs. 500

    Points: 548

    saw several jobs failed on the SQL Server, but from the job history, I couldn't see any reason for the failure. Then I checked the server logs, around that time, there was one entry:

    Error: 50000, Severity: 0, State: 1

    Is this severe? how to get more information about it?

    Thanks a lot!

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715107

    50000 and above are reserved for user defined errors.

    If you can post more info, we might be able to help.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • crab7

    Mr or Mrs. 500

    Points: 548

    thank you, Steve.

    Can you tell me how to get more info? is there a table which you can find user defined errors?

    It's a sql application, and the above are the only things I can think of checking....

  • K. Brian Kelley

    SSC Guru

    Points: 114455

    Check the sysmessages table. For instance:

    
    
    SELECT *
    FROM sysmessages
    WHERE error = 50000

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • Antares686

    SSC Guru

    Points: 125444

    Yes to be more specific we need the error message after that. However the severity is 0 which usually is an informational message only 17 and above warrant major concern. See "Error Message Severity Levels" in SQL BOL for a bit of background.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • sureshdeenu

    Right there with Babe

    Points: 736

    how can get more information about the Failed Job with error 50000

  • WI_PSC_DBA

    SSC Veteran

    Points: 297

    I got the 50000 error also on a SQL Agent Job.  In my case Step 2 | Advanced |  On success action drop down was 'Quit the job reporting failure'.  Something easily overlooked and correct.  This may be a good April 1st trick provided your stakeholders have a sense of humor.

Viewing 7 posts - 1 through 7 (of 7 total)

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