>SQL Server 2005.
>I have Integer Identifier column as primary key. Using CA class for Inserts & Updates.
>
>How do I get the new ID created in SQl Server in my VFP Cursor?
>
>The prob is similar to the VFP problem discussed in Thread #
1191628 and solved in Message #
1191764.
Similar way using SCOPE_IDENTITY().
There were several nice discussions for this problem, I can find you some.
If it's not broken, fix it until it is.
My Blog