CELKO (11/19/2012)
...
Oh, IDENTITY cannot be a valid key for table either.
...
Sorry to disappointing you again, but it really can!
Have you tried it? If you need our help we can show how it does work...
Just in case:
IDENTITY
Indicates that the new column is an identity column. When a new row is added to the table, the Database Engine provides a unique, incremental value for the column. Identity columns are typically used with PRIMARY KEY constraints to serve as the unique row identifier for the table.
from