sequence replication

  • It seems that if you create a sequence on a SQL 2012 database, the sequence is not replicated to a subscriber SQL 2012 database.

    Additionally, if you also create a table with a column that has a default value which comes from the sequence, the table creation fails, because sequences are not replicated.

    Any ideas on how to handle this situation?

    Note: It doesn't matter whether the sequence is used anywhere in the schema. It's still not replicated.

Viewing post 1 (of 1 total)

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