The SQL Server is MSSQL 2005
Trying to add a new roster, I get the following error on warn.log:
va.sql.SQLException: Violation of PRIMARY KEY constraint ‘jiveRoster_pk’. Cannot insert duplicate key in object ‘dbo.jiveRoster’
Is there a way to fix this may be updating the field used to know what is the last rosterID (I do not know how is inserted a new roster)?
It worked fine till last week.