Post reply

Getting a mail when a DB is created

  • February 27, 2015 at 8:34 am

    #1780631

    jclare (2/27/2015)

    Thanks for this. This is exactly what I was looking for. One question though. Where does it create this trigger? I looked at the master database under database triggers and it wasn't there.

    Thanks,

    Jim

    select *

    From sys.server_triggers

    Server side triggers are visible from server_triggers.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • February 27, 2015 at 8:35 am

    #1780632

    It's a server trigger, so it's created at the server level:

    Instance => Server Objects => Triggers.

    Have fun.

  • February 27, 2015 at 8:36 am

    #1780635

    Thank you.

  • February 27, 2015 at 8:37 am

    #1780636

    You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 4 posts - 16 through 18 (of 18 total)

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