Home Forums SQL Server 2008 SQL Server 2008 High Availability Not setting NOT FOR REPLICATION on subscriber foreign keys. RE: Not setting NOT FOR REPLICATION on subscriber foreign keys.

  • March 11, 2013 at 2:39 pm

    #1595731

    If you specify @sync_type='none' in sp_addsubscription, it seems SQL Server does not call sp_MSrepl_setNFR and mess up your foreign keys. This comes up in a different context (replicating to Sybase) in this forum post: http://social.msdn.microsoft.com/Forums/en-IE/sqlreplication/thread/e1743eed-2a5a-450c-843b-75c420909ae5.