<div>
Thanks so much made my life much easiler
</div>


<div>
<div class="content wysiwyg-content">
I am setting up Transactional replication, I need to set all the triggers in the production database to Not for Replication. At the moment I am using the Alter Trigger command to add the not for replication option for each trigger. But there is like 250 Triggers , is there a faster way or any sp i can use to make my life easiler now and in the future ?<br />
<br />
many Thanks<br />
<br />

</div>
</div>


I am setting up Transactional replication, I need to set all the triggers in the production database to Not for Replication. At the moment I am using the Alter Trigger command to add the not for replication option for each trigger. But there is like 250 Triggers , is there a faster way or any sp i can use to make my life easiler now and in the future ?

many Thanks



SQL Script to Set Triggers not for replication

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.