Well, I could just add another column to that table , copy data from the IDENTITY column into it, drop the DIENTITY column and recreate it, then copy data back and drop the extra column. But to do that I would need to drop all FK as well. It gets too complicated.

Thanks anyway.