SQL 2000 (No SP) on Win 2K Svr Sp2 Implementing Transactional Replication.
Some of my stored procedures are used in a nightly batch process. They disable triggers and then reenable triggers on some tables that I want to publish.
With replication enabled I get the following message from the DTS SQL Task that : Step Error Description:Cannot alter the table 'Company' because it is being published for replication.
Is there a way to disable a trigger on a table that is published for Replication?
DL
MCDBA, MCSD, MCT, etc.
Some of my stored procedures are used in a nightly batch process. They disable triggers and then reenable triggers on some tables that I want to publish.
With replication enabled I get the following message from the DTS SQL Task that : Step Error Description:Cannot alter the table 'Company' because it is being published for replication.
Is there a way to disable a trigger on a table that is published for Replication?
DL
MCDBA, MCSD, MCT, etc.