I have a table that has an identity field named Id. This field is used for partitioning and is not the key of the table. I have another Int64 field called OrgId which is the primary key.
When I try and do an update on this table it fails with the message: Cannot update identity column 'Id'
I guess my question is why? Can you have an identity column on a table that does not form part of the key?