Auto Increment Value

You can turn on identity insert. Please refer to this document:

http://technet.microsoft.com/en-us/library/ms188059.aspx