>>>
>>>I think it should be Integer Identity field in SQL Server. The seed value would be equal to the last PK + 1.
>>
>>But trying to automate this with SEDNA, how would I set the Integer Identity automatically? I have 200 tables in the database.
>
>I don't know, I haven't tried SEDNA. I just know the first part of your question :)

No problem, I am hoping someone has crossed this path before and found a solution.

Thanks for the reply..