<div>
You'll want to use a Trigger that fires when a DB is created or deleted.<br />
<br />
Here's a sample trigger that shows how to monitor when tables are created, it's not exactly what you need but it will get you on the right track.<br />
<br />
<a href="http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx" rel="ugc">http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx</a>
</div>


<div>
Hi aibusinesssolutions, <br />
<br />
The solution you gave does not apply to SS2000 as you can't create DDL Triggers in SS2000. <br />
<br />
Thanks for your help though!
</div>


<div>
Hi ScottPletcher,<br />
<br />
Thanks for the script. Work beautifully!<br />
<br />
Mary Lee
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm using SQL Server 2000 and would like to create an email alert to notify me when a database is created or deleted. Is there an simple and elegant way to do this?<br />
<br />
Thanks,<br />
Mary
</div>
</div>


Hi,

I'm using SQL Server 2000 and would like to create an email alert to notify me when a database is created or deleted. Is there an simple and elegant way to do this?

Thanks,
Mary

Creating an alert when database is created

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.