_RefObjCommon IDs sequence problem

01/20/2015 21:39 !Ego#1

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.

01/20/2015 22:59 Aaron*#2

Set RefObjcommon Is Identity = Yes

01/20/2015 23:04 !Ego#3

can u tell me how ?

01/20/2015 23:16 Aaron*#4

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.

01/21/2015 01:32 !Ego#5

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"

01/21/2015 14:52 Aaron*#6

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

01/21/2015 15:36 !Ego#7

Thanks :*