Replication Script

/*****************************************************************************************
Created: 13/07/2005
By: Andy Cox
Purpose: Simple script to identify triggers lacking the NFR attribute.

Modified on PI original to cater for triggers occupying > 1 record in syscomments.
******************************************************************************************/

select a.name
from sysobjects a
where a.xtype = 'TR'
and a.id not in (
select b.id
from syscomments b
where patindex( '%not for replication%', b.text ) >= 1
group by b.id
)