>>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.

One more way I forgot is to use new OUTPUT clause in SQL Server 2005 http://msdn2.microsoft.com/en-us/library/ms177564.aspx

I had a nice article on the topic, but could not find it right now in my favorites.

I googled "output clause SQL Server 2005 identity" and got lots of hits.