Alter replicated table - triggers,contraints

• Adam Angelini

  SSCrazy Eights

  Points: 8548

  More actions

  January 20, 2006 at 8:57 am

  #103054

  I have a table I would like to run 2 alter table statements on to disable check contraints and triggers so I can delete records from the table, then I would re-enable the tirggers and contraints. Problem is that you can't run an alter table statement on a table that is being replicated. Anyone know of a work around that could help me out?

• January 23, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Aaron-296258

  SSC Enthusiast

  Points: 178

  More actions

  January 23, 2006 at 11:45 pm

  #616576

  I guess u need to stop the replication first. Have not seen any other way on the web as of now.