You will not be able to use the identity column for SQL Server, since it will determine the ids. But if you want the functionality to determine a missing id in a column that is in numeric order then you can use the following select statement as a guideline:

The following will return the lowest missing id_field value:

SELECT MIN(id_field) + 1 AS id_field
FROM MyTable a
WHERE NOT EXISTS
    (
    SELECT *
    FROM MyTable b
    WHERE b.id_field = a.id_field + 1
    )

>hi , every body
>
>i want watch on identity column, i meant to say that if any column delete from table which has identity column, when new column add check identity column that any number is missing if then insert that missing number if not then continue with next number.
>
>E.g 1,2,3,4
>
>Now i delete 2 no column , When new column add it will be 2, if no column delete then next will be 5
>
>Thanks
>Mufi