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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2008-01-28 : 22:31:02
|
| Hi thereI've created the new alert by going to use the following stored procedure:EXEC msdb.dbo.sp_add_alert @name=N'Severity19 Error', @message_id=0, @severity=19, @enabled=1, @delay_between_responses=180, @include_event_description_in=7, @category_name=N'[Uncategorized]', @job_id=N'00000000-0000-0000-0000-000000000000'GOBut the result has a strange characters between 'Severity' and '19 Error' in sysalerts column. So I can't even drop this by using sp_delete_alert. My question is how to access and modify the sysalerts system table cause I don't think you can access system table anymore?BTW ... I am using the 90.00.3042 (Sp2).Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-28 : 22:33:11
|
| No you can't. What kind of error did you get when try to delete it? |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-01-28 : 22:36:41
|
quote:
Originally posted by rmiao
No you can't. What kind of error did you get when try to delete it?
Msg 14262, Level 16, State 1, Procedure sp_delete_alert, Line 30The specified @name ('Severity 19 Error') does not exist. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-28 : 22:42:54
|
| Tried copy whatever name from sysalerts and put it in sp_delete_alert? |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-01-28 : 22:47:11
|
quote:
Originally posted by rmiao
Tried copy whatever name from sysalerts and put it in sp_delete_alert?
It works! By going to EXEC msdb.dbo.sp_delete_alert @name=N'Severity 19 Error'Have a new line after Severity.Thanks |
|
|
|
|
|
|
Alert