Script to find to see newly created databases

• Diyas

  SSCarpal Tunnel

  Points: 4851

  More actions

  August 31, 2016 at 1:13 pm

  #400659

  Hi,

  i am developing the script which will give the if new database is created on the server we need to get the mail .

  Any ideas on this.

• mk7dba

  Old Hand

  Points: 357

  More actions

  August 31, 2016 at 1:24 pm

  #1898644

  You can create a trigger to do exactly that.

  See this link:

  https://www.mssqltips.com/sqlservertip/2864/email-alerts-when-new-databases-are-created-in-sql-server/

  There was also a thread on this same website answering this:

  http://www.sqlservercentral.com/Forums/Topic1071980-1550-1.aspx