if you know for certain that there are no duplicates in that column, simply make it an identity column via EM as pointed out before. As for the second question I'm not sure to understand correctly. Are you asking how to reverse a column from identity to non identity (if so, simply set the yes in Identity to no via EM) or are you asking how to allow NULL in an identity column. I don't think that this is possible.

Cheers,