Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error 50000 Expand / Collapse
Author
Message
Posted Tuesday, July 09, 2002 9:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, February 16, 2004 1:43 PM
Points: 28, Visits: 1
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!




Post #5322
Posted Tuesday, July 09, 2002 9:27 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:31 PM
Points: 32,780, Visits: 14,941
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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #37091
Posted Tuesday, July 09, 2002 10:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, February 16, 2004 1:43 PM
Points: 28, Visits: 1
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....





Post #37092
Posted Tuesday, July 09, 2002 10:35 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #37093
Posted Wednesday, July 10, 2002 8:10 PM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: 2 days ago @ 3:54 PM
Points: 8,369, Visits: 733
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)



Post #37094
Posted Thursday, December 17, 2009 9:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 12:24 PM
Points: 43, Visits: 126
how can get more information about the Failed Job with error 50000
Post #835772
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse