"Pauly C" <paulysc@optonline.net> wrote in message
news:D5D61D6A-576A-4F4F-89F2-07EE4F7981CA@microsoft.com...
> 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
>
>
> "Paul Ibison" wrote:
>
>> 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)
>>
>>
>>