In this blog post, let’s learn about the error message “21830 – You cannot specify schema_option 0x4 (script identity as identity rather than the base data type) for article ‘%s’. The value specified for the parameter @identityrangemanagementoption is NONE. To replicate identity as identity, the value must be MANUAL or AUTO for publications that do not support queued updating subscriptions.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
21830 – You cannot specify schema_option 0x4 (script identity as identity rather than the base data type) for article ‘%s’. The value specified for the parameter @identityrangemanagementoption is NONE. To replicate identity as identity, the value must be MANUAL or AUTO for publications that do not support queued updating subscriptions.
Reason for the Error
To be update soon…
Solution
To be update soon…