SQL Server Transaction Replication Issue: BIT Columns Not Refreshing

• krunalpatel155

  SSC Rookie

  Points: 37

  More actions

  September 2, 2024 at 2:45 am

  #4453135

  Hello Everyone,

  I have a database that is being copied to six subscribers with several publications. I have noticed that sometimes, when updating the bit data typed column, the updates are not being sent to all subscribers. Out of six, five subs are working perfectly while one is not. I've also reviewed the schema options, and they are identical for everyone, but unfortunately it's not functioning correctly. I've attempted to solve the problem, but I haven't had any success! Could someone who has experienced this before and found a solution please assist me?

  Environment:

  OS: Windows Server 2019

  Database Server: SQL Server 2019, Standard Edition, CU-28 applied

   

  Thanks,

  Krunal Patel

   

  Thanks & Regards,
  Krunal

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  September 3, 2024 at 3:10 am

  #4453428

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.