>
>What would cause SELECT @@identity to return an incorrect ID?

The @@identity stores the latest identity value inserted for particular connection. If you've Insert trigger that inserts into another table with identity column, than you'll get identity value for that insert.