Last inserted identity

May 24 2012 5:46 AM

Hi,

I am trying to get last inserted record in Table on REMOTE SERVER.
I tried using ident_current, SCOPE_IDENTITY() and @@Identity but none of them worked.

Can anyone tell me how to get it??

Thanks in advance.