title: Best way to get identity of inserted row in Linked server?
body: <p>I am inserting record in a remote Sql Server using Linked server, Now I wanna get the id of inserted record. something like <code>scope_identity()</code> in local server.
  My remote sql server is 2000 version. </p>
  
  <p>I have seen <a href="https://stackoverflow.com/questions/4537560/get-identity-from-another-serverlinked-server">this post</a> but I can't add any stored procedures in remote sql server</p>