MS SQL 서버에서 자동증가, autoincrement 처리

Make sure that the Key column's datatype is int and then setting identity manually, as image shows

Or just run this code

경축! 아무것도 안하여 에스천사게임즈가 새로운 모습으로 재오픈 하였습니다.
어린이용이며, 설치가 필요없는 브라우저 게임입니다.
https://s1004games.com

-- ID is the name of the  [to be] identity column
ALTER TABLE [yourTable] DROP COLUMN ID 
ALTER TABLE [yourTable] ADD ID INT IDENTITY(1,1)

the code will run, if ID is not the only column in the table

[출처] http://stackoverflow.com/questions/10991894/auto-increment-primary-key-in-sql-server-management-studio-2012