alert for dropped database

Hello all,
SQL2K SP3a
I would like to be notified when a user drops a database in my sql server.
Is there any way to build such an alert?
Thanks, sqlgirlThere are several ways...most of them would involve some sort of batch
process that runs occasionally and compares the names of databases to the
previous run list...
Another way might be to run SQL Trace, loading data to a database table, and
place a trigger on the table to read the sql and notify it the command is a
drop database...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Biva" <biva.yauchler@.redprairie.com> wrote in message
news:421cbc5b$0$43503$39cecf19@.news.twtelecom.net...
> Hello all,
> SQL2K SP3a
> I would like to be notified when a user drops a database in my sql server.
> Is there any way to build such an alert?
> Thanks, sqlgirl
>
>sql

alert for dropped database

Hello all,
SQL2K SP3a
I would like to be notified when a user drops a database in my sql server.
Is there any way to build such an alert?
Thanks, sqlgirl
There are several ways...most of them would involve some sort of batch
process that runs occasionally and compares the names of databases to the
previous run list...
Another way might be to run SQL Trace, loading data to a database table, and
place a trigger on the table to read the sql and notify it the command is a
drop database...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Biva" <biva.yauchler@.redprairie.com> wrote in message
news:421cbc5b$0$43503$39cecf19@.news.twtelecom.net. ..
> Hello all,
> SQL2K SP3a
> I would like to be notified when a user drops a database in my sql server.
> Is there any way to build such an alert?
> Thanks, sqlgirl
>
>