• You need to make sure that the new data type is compatible with IDENTITY.

    Identity column must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, and constrained to be nonnullable.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]