do you mean enabling identity insert on id column or modifying a column to be identity? former is possible but for you dont have direct method for latter. you need to create a new id column, copy current values of current column and then drop current one. you dont need dts to transfer table to another db of same server. just script out table and constraints,.. from sql enterprise manager if 2000 or sql mgmnt studio if sql 2005 and apply script in other db. then use INSERT...SELECT to populate the data from current table to newly created one.