Post reply

Database mail notification when new database is created?

  • September 8, 2008 at 8:06 am

    #154702

    Hello,

    I'm pretty new to these forums so please excuse me if this has already been covered. The company I work for has just moved to SQL Server 2005, I have setup the servers and many databases and all is going well. Unfortunately, they also use SharePoint; I am looking for a way to receive an email notification when a new database is created on the server. I have already setup Database Mail and that too is working fine.

    Thanks

  • September 8, 2008 at 8:44 am

    #868499

    You can capture the new database using a DDL trigger or an event notification. If you store that data off in some table, then you can track it. You can also use the Database Mail stored procedures in the trigger to send a notification to yourself when the event fires.

  • September 8, 2008 at 9:25 am

    #868519

    Thanks for the response.

    The notification would really only need to say that a new database had been created. Nothing fancy.

  • September 8, 2008 at 9:43 am

    #868546

    That WMI event has now totally confused me :unsure:

    Please remember that I am new to SQL Server 2005. Make it as idiot proof a possible.

    Many thanks

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

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