Creating Alert and Notifications for Replication Issues on SQL Server 2005!!!

• Devesh_Srivastava

  SSC Eights!

  Points: 983

  More actions

  August 6, 2012 at 1:00 am

  #279237

  Hi All,

  I have been assigned a Task to set up Alert and Notifications for all the Issues arising in Replication i.e. :

  1. Any issue arising in Publisher

  2. Any issue arising in Distribution

  3. Any issue arising in Subscriber

  If I am not able to implement all of the above, the least that I have to do is to create Alert and Notification for the 3rd point-Any issue arising in Subscriber

  Could you guys please help me or give me an idea how can I setup Alerts and Notifications for the above scenarios?

  Thanks

  Devesh

• derek.colley

  SSCrazy Eights

  Points: 8040

  More actions

  August 6, 2012 at 3:01 am

  #1521877

  Alerts here -> http://msdn.microsoft.com/en-us/library/ms180982.aspx

  Replication here -> http://msdn.microsoft.com/en-us/library/ms151198.aspx

  Replication with alerts here -> http://technet.microsoft.com/en-us/library/ms151752.aspx

  and here -> http://msdn.microsoft.com/en-us/library/aa237180(v=sql.80).aspx

  and here -> http://www.mssqltips.com/sqlservertip/1901/customized-alerts-for-sql-server-transactional-replication/

  Hope this helps.

  ---

  Note to developers:
  CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
  So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

  Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
  My blog: http://uksqldba.blogspot.com
  Visit http://www.DerekColley.co.uk to find out more about me.

• Devesh_Srivastava

  SSC Eights!

  Points: 983

  More actions

  August 7, 2012 at 7:04 am

  #1522556

  Guys,

  More suggestions will be highly appreciated!!!!!

  Thanks

  Devesh