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 |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2008-10-28 : 15:15:14
|
| Hi,I want to monitor any error pop up SQLserver log.Either I can do thru script or SQL mail.please suggest which one is good way to do and what are risk of doing thur SQL MAIL?Thanks,- |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-28 : 16:48:09
|
| what errors are you looking for? |
 |
|
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
Posted - 2008-10-29 : 09:54:10
|
| any kind of errors like if DBCC result show inconsistency error,any job failures,DB corruption error etc. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-29 : 17:48:49
|
| You can setup notification to your email for jobs related to DBCC checkdb or any job failures. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-29 : 17:50:16
|
| We use MOM for monitoring SQL Server related issues like:Log file is full,DBCC error and more |
|
|
|
|
|
|
DB MONITORING