I believe you are prohibited from inserting into an identity column.
>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer