Unanswered: Replication in SQL 2008 SP1 - sp_addsubscription results in error
Adding a Subscription using the script below results in error - Cannot insert the value NULL into column 'nosync_type', table 'HFHS_2512_PROD.dbo.syssubscriptions'; column does not allow nulls. INSERT fails.
The Distributor & Publisher are in the same server (SQL 2008 SP1)
The Subscription server is also SQL 2008 SP1