>>I have an application in Asp.Net that writes to a SQL Server table. This SQL Server table has an Identity column.
>>
>>How can I return the value of the Identity column after performing an Insert into the table?
>>
>>Thanks,
>>
>>Jerry
>
>Jerry,
>You would request SCOPE_IDENTITY back. Instead I suggest you to use GUID as unique IDs. You don't need to request back then because you know them before inserting.
>Cetin

I second that! To go even further try this!

http://www.informit.com/articles/article.asp?p=25862&rl=1