1. identity columns can't have null values
2. To change an identity column into another one add another column with same data type, update the new columns value and remove the identity column
3. You can do a similar thing to convert an int column into identity with out the update, since indentity columns cannot be updated
Cheers,
Prithiviraj Kulasingham
http://preethiviraj.blogspot.com/