>>What is the syntax for the ALTER TABLE command to change an existing column to an identity column.
>
>I know for sure that it cannot be done with the ALTER TABLE in SQL 2000 and doubt that it can be done in SQL 2005 this way either.
It can't :-( just tested.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.