Merge Replication Email Notification on error
in [Replication]
|
Prev: Replication from 2005 to 2000 fails because of CREATE TYPE command
Next: Script or command to reinitialize a publication
From: pezi179 on 19 Mar 2010 04:13 Hi is there any built in notification setting (SQL Server 2005) when an error occurs during replication. by error I mean for example if a sync failed due to an integrity violation - or something like this. tia pezi
From: Ben Thul on 19 Mar 2010 10:08
Take a look at SQL alerts (in Management Studio, they can be found under the SQL Server Agent). You'll need to know what error number is given when the situation that you want to monitor occurs. Once you do, you can have the alert take action when it does occur. HTH. -- Ben On Mar 19, 3:13 am, pezi179 <pezi...(a)hotmail.com> wrote: > Hi > is there any built in notification setting (SQL Server 2005) when an > error occurs during replication. > > by error I mean for example if a sync failed due to an integrity > violation - or something like this. > > tia > pezi |