@@IDENTITY (Transact-SQL)

Note The calling stored procedure or Transact-SQL statement must be rewritten to use the SCOPE_IDENTITY() function which will return the latest identity used within the scope of that user statement, and not the identity within the scope of the nested trig

technet.microsoft.com