sql server replication: Disabling triggers not involved in replication in SQL 2000 -- sql server replication

Disabling triggers not involved in replication in SQL 2000

AK_Craig
2/13/2006 3:40:28 PM

sql server replication:

I am experimenting with replication and recently set up a prototype
transactional replication with about a dozen publications and perhaps twice
as many articles. All has gone smoothly so far. One item that is causing
much gnashing of teeth is the fact that I cannot disable a pre-existing
trigger that has nothing to do with the replication.

Msg 4929, Level 16, State 2, Line 1
Cannot alter the table 'XXXXX' because it is being published for replication.

Any help greatly appreciated.

Re: Disabling triggers not involved in replication in SQL 2000

Paul Ibison
2/14/2006 12:00:00 AM

Craig,
you won't be able to do this sort of statement: "alter table suppliers
disable trigger all" but you can issue an alter trigger statement. If there
are only a few triggers this might be practical for you.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)