>I believe you are prohibited from inserting into an identity column.

You can set Identity_Insert ON to insert into the column. The only use I've seen for this is when copying table data that need to keep their primary key (the identity column) intact because other tables have FKs pointing to it.

>
>
>>In SQL Server, all you do is define a column as an integer (normally) ans specify that it is an identity column.
>>
>>That's all there is.
>>
>>Every time you insert a record into the table, the identity column with be incremented to a unique value. Normally you do not insert a value into an identity column - it populates automatically.