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 |
deal11deal1
Starting Member
34 Posts |
Posted - 2011-09-16 : 12:11:55
|
Hello all, i was looking to set up sql server error log scan and send notification to me/DBA team.after searching find out this blog which i implemented but have few issuehttp://sqlserverblogforum.blogspot.com/2011/02/how-to-get-sql-server-critical-errors.htmlin the send dbmail Sp. during testing i changed the recovery model in one of the database.it gets populated in the table but email only send me a old error message but not the lastest one For examplethis is what i got in the emailDATE: Aug 12 2011 11:19AM PROCESSINFO: Logon TEXT:Error: 17806, Severity: 20, State: 2. ( which occured on Aug 12)the latest error in the error table is as follows " Setting database option RECOVERY to SIMPLE for database DBA_TEST. "( on sept 16)but i dont get that in the email text.can anyone help me, kind a lost here.Thanks |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-09-19 : 04:44:12
|
the latest error in the error table is as follows " Setting database option RECOVERY to SIMPLE for database DBA_TEST. "This is not an error, it is information only. There is no errorcode for this log item.. |
 |
|
|
|
|