>>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.aspxI 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.
If it's not broken, fix it until it is.
My Blog