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 |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2007-10-23 : 09:57:04
|
| I've setup an alert notifying me when there is a state change in *any* one of my databases.SELECT * FROM DATABASE_MIRRORING_STATE_CHANGEThe problem is my email that is sent contains no info as you can see here.DATE/TIME: 10/23/2007 9:46:40 AMDESCRIPTION: COMMENT: (None)JOB RUN: (None)How can I get the specific info into this email e.g. Database, Problem encounterd.... ?thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-23 : 22:46:37
|
| How did you set alert? |
 |
|
|
|
|
|
Send email when Mirroring Event changes