SQL Server Performance

Repl Issue

Discussion in 'SQL Server 2005 Replication' started by sql_jr, Aug 5, 2007.

  1. sql_jr New Member

    stored procedure which is causing the locks….We actually dropped the publication, so what should we do now?
    Msg 548, Level 16, State 2, Procedure my_sproc, Line 10
    The insert failed. It conflicted with an identity range check constraint in database myDB, replicated table 'dbo.myTable, column 'MyID'. If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_adjustpublisheridentityrange; for the Subscriber, run the Distribution Agent or the Merge Agent.
  2. satya Moderator

    Better refer that check constraint which specifics that the values can only be in a certain range or of a certain patters. Look at the Column's check constrains though EM to see what has been setup.
    Also try to optimize that SP in order to avoid the locks.

Share This Page