Which article property for IDENTITY?

• netmikem

  SSCarpal Tunnel

  Points: 4001

  More actions

  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.

• noeld

  SSC Guru

  Points: 96590

  More actions

  July 12, 2007 at 8:13 am

  #718977

  schema_option must contain bit 0x04 "ON"

  
  * Noel

• netmikem

  SSCarpal Tunnel

  Points: 4001

  More actions

  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