Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Amber_Robertsona
Starting Member
4 Posts |
 Posted - 2007-05-11 : 06:33:18
|
| 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 RegardsAmber Amber |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-11 : 10:01:29
|
| Sysmessages just holds all system messages definded on the server, should search sql server log or windows event logs to see when the logged error happened. |
 |
|
|
Amber_Robertsona
Starting Member
4 Posts |
Posted - 2007-05-11 : 10:03:19
|
| Thank you for the suggestion. Does the data shown in SQL Server Logs in the Enterprise manager stored in a table within the database as well?Any suggestions appreciated.Kind RegardsAmberAmber |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-11 : 10:13:46
|
| No, it's text file. |
|
|
|
pootle_flump
1064 Posts |
Posted - 2007-05-14 : 08:35:35
|
| Duped at dbfhttp://www.dbforums.com/showthread.php?t=1618177 |
|
|
|
|
|
|
sysmessages