>We're using SELECT @@IDENTITY right after the statement, but we use this only on the tables that don't have triggers. I don't like this solution much, but I don't see a better alternative. IDENT_CURRENT has its own problems.
>
>
>Out of curiosity (and maybe you answered this in another message and I missed it)....why aren't you using SCOPE_IDENTITY?
>
>Most of the environments I've been in, IDENT_CURRENT would not have been practical at all, for the reasons you stated.

SCOPE_IDENTITY() does not work calling by itself :( In other words, if we're using Remote Views and tableupdate, I think there is no other choice.

BTW, I think I did ask this question myself some time ago and didn't get an answer...

This is my thread on this topic

Re: SPT, updatable cursor and last identity value Thread #1458392 Message #1458444