MS-SQL: wheres auto increment?

It's been a long time since I've had to check an index for the highest value, then add 1, to create a new unique key. These past few years, it seems this is usually done for you. But now that I'm working with MS-SQL, I don't see it. Is it there? It's doesn't seem to be inherent in the definition.you will need to set the field/column to be an identity column

Make it an integer - don't allow nulls - then, depending on which app you're using to create it - set the column to be an identity column|||Set Identity Seed = yes for the column|||Identity Seed is numeric and indicates the starting number to use for Auto Numbering...It cannot be set to "Yes"|||I think he meant "Identity". You set the Identity to yes and identity seed is the starting number.|||Yea, sorry, it was supposed to be "Identity"