title: scope_identity vs ident_current
body: <p>After much research I am a little confused by which identity tracker I should use in sql. </p>
  
  <p>From what I understand scope_identity will give me the last id updated from any table and ident_current will will return the last id from a specified table.</p>
  
  <p>So given that information it would seem to me the best version to use (if you know which table you will be updating) is ident_current. Yet, upon reading it seems most people prefer to use scope_identity. What is the reasoning behind this and is there a flaw in my logic?</p>