Sysmessages

May 11, 2007

I would like to write a SQL stored procedure, to be used on a DBA dashboard website, showing errors that have happened on current system day. I have found that errors displayed in the SQL Server Logs are stored in sysmessages table but I cannot find a column showing date/time. Does anybody have any ideas where I can get the date/time of either when the error happened or when the error was written to the SQL Server Logs?

Any suggestions much appreciated.

Kind Regards

Amber

View 8 Replies

Sysmessages Table

Aug 2, 2007

Hi All,

The sysmessages table in the master database has a column called dlevel and this column has the following values: 0, 1, 2, 4, 127, and 128. I found out that dlevel 128 means "always log to windows event log". Does anybody know what the other 5 values mean?

Thanks

View 1 Replies View Related

@@error And Sysmessages

Oct 16, 1998

@@error and sysmessages

In a stored procedures i need to have a complete string about error that occured.
E.g.

Msg 2714, Level 16, State 1
There is already an object named `_ReadCcAccount` in the database.

When an error occures, I do @error=@@error number and can find string
in sysmessages according @error.
By this method I find only string

->There is already an object named `%.*s` in the database.

Does anybody know how to find original message that in this case have also name of the table?

I can prepare some information into variable before the desired action. But I do many things in cycles based on setup tables. This I dont see an elegant solution.

We have a bank system based on stored procedures in SQL. We have lots of strored procedures and we have our own errorlog system. We need to know very precissely about errors.

Thanks very much

Ludek

bouska@login.cz

View 2 Replies View Related

Sysmessages Table

Aug 1, 2007

Hi All,

I think I've posted this thread already but I can't find it, so I'll post it again. The sysmessages table in the master database has a column called dlevel and this column has the following values: 0, 1, 2, 4, 127, and 128. Does anybody know what these values mean?

Thanks.

View 2 Replies View Related

RAISERROR Could Not Locate Entry For Error 60002 In Sysmessages.

Feb 14, 2008

My C# asp.net web application is throwing an exception and the message is the following:

RAISERROR could not locate entry for error 60002 in sysmessages.
The error occurs in the stored procedure. Can anyone tell me what I need to do to fix this problem? Note that if I manually run the stored procedure, I get the following error message:
Msg 2758, Level 16, State 1, Procedure GetPortalSettings, Line 74
RAISERROR could not locate entry for error 60002 in sysmessages.

View 3 Replies View Related