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.
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.
