>I can't go changing my primary key datatype, the entire application has been built for using integers. Isn't there another way?
Then there is ( < s > wish there weren't and everyone forced to use GUID) but I can't gurantee the reliability under all cases (not me SQL server actually).
If you're updating via a stored procedure then return Ident_current(tablename) - do not use SCOPE_IDENTITY() or @@Identity as they are worse. Read in SQL server books online why they are not reliable 100%.
Without a stored procedure you need to requery('viewalias'). However think twice if you really need that value.
Cetin