auto numbering

plz tell me how to make a column(id)that is a primary key to be auto numbered .

Hi,

you have to create a new column with the identity property and copy the primary key values over to the identity column, then drop the old non-identity column.

There is no ALTER Column or ALTER table to do this.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de