Not for replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pauly C - 29 Mar 2006 05:27 GMT

Is there a way to add the "Not for replication" switch for triggers and
foreign keys other then dropping and adding them again?

Thanks in advance,
Pauly C

Reply to this Message

Paul Ibison - 29 Mar 2006 08:53 GMT

You can use ALTER TRIGGER but for the FKs you'll need to drop and recreate.
These scripts can help you identify them:
http://www.replicationanswers.com/Script15.asp
http://www.replicationanswers.com/Script11.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message

Pauly C - 29 Mar 2006 14:51 GMT

Paul,

Thank you for the links, I’ve already used those scripts since I have your
site bookmarked . I had to write a script to deploy the NFR attribute
addition. I wrote a script last night just incase there wasn’t a way to just
flick the NFR switch on them. I can send it to you if you like; it seems to
be working pretty well.

Thank you
Pauly C

> You can use ALTER TRIGGER but for the FKs you'll need to drop and recreate.
> These scripts can help you identify them:
[quoted text clipped - 4 lines]
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)

Reply to this Message

Paul Ibison - 29 Mar 2006 16:21 GMT

Please can you post it here so others can see it, and please also send it to
paul . ibison @ replicationanswers . com and I'll post it up (under your
name).
Cheers,
Paul

> Paul,
>
[quoted text clipped - 18 lines]
>> (recommended sql server 2000 replication book:
>> http://www.nwsu.com/0974973602p.html)

Reply to this Message