Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Error 8102: Cannot Update Identity Column

    Hi,

    I'd set up Transactional Replication btw 2 servers running on MSSQL 2000.

    However, from time to time, I encounter Error 8102. I try to reinitialise the subscription but failed. After I delete the current subscription and PUSH a new one, it will works fine again.

    I'm curious why this is happening as I'd already set all the tables (articles) in the subscriber to "YES, not_for_replication".

    Any idea?

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: Error 8102: Cannot Update Identity Column

    Originally posted by da_i256
    Hi,

    I'd set up Transactional Replication btw 2 servers running on MSSQL 2000.

    However, from time to time, I encounter Error 8102. I try to reinitialise the subscription but failed. After I delete the current subscription and PUSH a new one, it will works fine again.

    I'm curious why this is happening as I'd already set all the tables (articles) in the subscriber to "YES, not_for_replication".

    Any idea?

    Thanks.
    check this thread:
    http://dbforums.com/arch/7/2003/5/779346

  3. #3
    Join Date
    Mar 2004
    Posts
    3

    Cool Error 8102

    thanks, harshal_in...

    then link did provide some insights into the matter.

    anyone else got any idea?

    thanks.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Have you gone thru the MSDN link referred in the above post, it must have resolved with the workaround mentioned.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Mar 2004
    Posts
    3
    Thanks guys...

    the problem solved... :>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •