Post reply

Which article property for IDENTITY?

  • July 10, 2007 at 2:02 pm

    #177432

    Hello. We're using SQL Server 2005 transactional replication.

    We have a few tables having IDENTITY columns, which have been defined as NOT FOR REPLICATION.

    My question ... which article property in the publication needs to be set to TRUE in order to have the identity attribute replicated?

    Cheers.

  • July 12, 2007 at 8:13 am

    #718977

    schema_option must contain bit 0x04 "ON"


    * Noel

  • July 12, 2007 at 9:18 am

    #719011

    Thanks for the reply. I actually meant the option via the Article Property window in the publication GUI.

    For example, 'Copy default value specifications'.

    Which option in the GUI should be set to True in order for the IDENTITY option to be replicated?

    Regards,

    - Mike

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply