In attempting to set up a transactional replication subscription via the UI, I keep getting the error that I cannot insert a Null into the MSSubscription_agents table. Originally, this was on the allow_subscription_copy column.
One resource suggested altering the column to allow Nulls but that only moved the issue to the attach_state and, later, attach_version columns. My immediate issue was resolved with these changes BUT I'm really concerned that I need to alter a system
table in order to allow a fairly simple replication subscription to be configured. Has anyone run into this issue and is there a better work around available?
I'm running SQL 2008 Enterprise Edition SP1 in a 64-bit environment on both the Publisher/Distributor and Subscriber servers.
View Complete Post