You can use SCOPE_IDENTITY() system function to get the value of the IDENTITY column after insert. I'm not sure how you can return it back to VB.NET but I'm using stored procedure OUTPUT parameter to do the same when it's called from VFP.

>I have a table that store records that have an auto incrementing field called Counter. In my VB.NET app I am triggering a stored procedure to insert a record into this table, but I would also like to somehow get the Counter value back to my app. Any advice on how to do this?