_RefObjCommon IDs sequence problem

[!Ego]

Hello ElitePvperz ! ,,

I am using the original DB working on SQL 2012 yesterday i was adding a new avatar when i was copying the lines i edited the IDs to my last one +1 every time but when i paste it on the table i got a error on the lines when i restarted the table the error gone but the IDs of the new lines wasn't going with right sequence

example :

PHP Code:

Service    ID
1        2000
1        20154 


Thanks.. for reading.

[Aaron*]

Set RefObjcommon Is Identity = Yes

[!Ego]

can u tell me how ?

[Aaron*]

right click the table _refobjcommon -> Design
Select ID Column and scroll down till you find Identity specification ,expand it and double click the word 'NO' near Is identity, it will be changed to yes. save the changes and you're done.

[!Ego]

It can't be saved i got a error
"The changes u made need to drop the table and re-create and this table can't be re-created"

[Aaron*]

SQL -> Tools -> Options -> Designer -> uncheck prevent saving changes when .....

[!Ego]

Thanks :*