July 10, 2002 at 1:38 am
hello everybody,
i have to alter a table which is being published in transactional replication (SQL2K, SP1). i have to add several columns which will NOT be part of the publication and i understand that i can just add them without any effect on the replication (which i do not want to touch). Furthermore i have to add a trigger to this table and that's where i'm not so sure if it will affect replication (i think it won't but i have no experience) - i cannot find any information about this.
Can you tell me if a trigger will influence replication and if yes, how?
Thank you for your help,
greetings,
Kerstin
July 11, 2002 at 8:05 pm
We have transactional replication now (in SQL Server 7.0 SP 3) and have a few tables with triggers on them. We haven't had any problems. I doubt a trigger would cause problems with replication unless it interferes with replication. A trigger that modifies data in the row after an update could cause the row to be replicated again so that is one thing to consider. I know the triggers we have don't fire too often and only update one row each time they fire.
I hope this helps.
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
July 12, 2002 at 5:31 am
Adding the columns using a standard alter wont affect your pub at all. Trigger works as Robert describes regardless of how many rows it modifies.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply