When removing the identity property from a column via the GUI design table option I believe the table (and if the column is a key field; any associated non-clustered indexes) are recreated.
Does anyone know of a way to drop the identity property from a column without causing this overhead?