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
>
>

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
>
>

Alert for Conflicts

Hi,
Is it possible to be notified whenever a conflict occurs during merge sync?
With a mechanism like alerts.
Thanks in advance,
Leila
You can use the interactive resolve in conjunction with Windows
Synchronization Manager.
Other than that you have to poll the tables for this.
RelevantNoise.com - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:udATMJkJIHA.4684@.TK2MSFTNGP06.phx.gbl...
> Hi,
> Is it possible to be notified whenever a conflict occurs during merge
> sync? With a mechanism like alerts.
> Thanks in advance,
> Leila
>