Post reply

Alert Deleted But Still Firing

  • March 28, 2006 at 8:57 am

    #90729

    I created an alert (18453) to audit successful logins. After I was done with the alert I made I edited the alert 18453 to disable event log logging and then deleted the alert. My problem is that the alert is deleted but it continues to log to the SQL Server error log and the windows application log. I have tried restarting the SQL Server Agent and even had the server rebooted over the weekend. Has anyone else had this problem? Where is this configured and how can I disable it?
    Kindest Regards,

    Michael Perdue

  • March 28, 2006 at 9:19 am

    #629219

    This is on SQL Server 2000. I posted in the wrong forum. I have since posted in the 2000 forum. Thanks.

    Kindest Regards,

    Michael Perdue

  • March 29, 2006 at 3:24 am

    #629417

    That's server level auditing, not a trigger:

    Go to the properties of the SQL Server, go to Auditing and select sucessful, faulre, all or none.

  • March 29, 2006 at 10:13 am

    #629573

    Thanks. You were correct that it was set to "All". I set it back to "Failure" and will have to schedule a restart.

    Kindest Regards,

    Michael Perdue

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply