• 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/