Last inserted identity

Question

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.