Post reply

SQL Alerts ??

  • July 10, 2007 at 4:24 pm

    #68858

    I cannot remember this, as I have not been in a database admin role in some time. I have been more of a developer.

    So here is my question....

    What is it called where you can be notified when someone creates an account, or an incorrect login, or a database out of space. I want to be notified when something like that happens in a database. I just cannot remember the name, I am thinking an alert. But I want to be positive, so that I can create some on the databases that I am now an admin.

    Thanks

    Andrew SQLDBA

  • July 10, 2007 at 8:39 pm

    #718480

    You can create triggers to alert you when a login is created.

    Regards..Vidhya Sagar
    SQL-Articles

  • July 10, 2007 at 10:48 pm

    #718490

    Mmmm, you can't actually create a trigger on a system table.

    Alerts are the way to go. In Enterprise Manager, got to Management--> SQL Server Agent --> Alerts

    If you create an Alert on Error number 15298, you can get notification of the creation of a new login.

  • July 10, 2007 at 11:29 pm

    #718497

    Yes you can't use triggers with system tables in 2000 only way is to use alerts but i have seen most times that does not work for some reason. If 2005 go for DDL triggers.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 11, 2007 at 8:42 am

    #718657

    Thank you everyone.

    Andrew SQLDBA

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

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