Can someone please help.
I have a job which runs everyday, and has a line of code:
ALTER TABLE DBName..TableName DISABLE TRIGGER TriggerName
Unfortunatelly the Table is part of transactional replication, and I recieve the following message:
Is there anyway of disabling a trigger on a replicated table without dropping the article from the publication??
The Publication exists on a SQL Server 2000 database and is subscribed to from a SQL Server 2005 database, with a SQL 2005 distributor.