title: alter a table column and set identity from max existing in that column in sql server 2008
body: <p>I have a Column with MaxCode name, in Mytable that filled before,now i want alter this column and set it type to identity that start with max number existing in column MaxCode </p>