Snapshot replication

• Kwisatz78

  SSChampion

  Points: 12478

  More actions

  July 5, 2010 at 5:46 am

  #234643

  hi all, we use a weekly snapshot replication job to take a bunch of articles across to another server. Last night the job failed, and when I restarted it the job completed successfully but none of the data was replicated across. I also re-initialised the subscriptions and generated a new snapshot but again the data was not replicated.

  I am now trying to re-configure the replication job, and getting an issue I with a database trigger. It just always says that the definition of the object has changed since compilation. Has anyone else has any experience of using database triggers with replication?

  Thanks

• noeld

  SSC Guru

  Points: 96590

  More actions

  July 6, 2010 at 1:59 pm

  #1189310

  Check this out: http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/bba53aeb-6bdf-4cfb-b62f-fc4443e171c0/[/url]

  
  * Noel