>Hello Sergey,
>
>I hope you can help me with following problem:
>
>a table with a field myfield filled with data. Now I want to make myfield an identity (without losing the original data obviously) starting from
>max(myfield)+1. What's the best way to proceed ?
>
Hans,
In the Enterprise Manager go to your table, right click on it and select Designe Table. Find field you want to make identity and set Identity to 'Yes' and clcik save icon. The column became Identity column and data in that column will be preserved.
--sb--