Why not to use @@identity in TSQL?

Travis Laborde has a great tip on why not to use @@identity in TSQL code and use scope_identity() instead.

BTW, the official Yukon web site is (also) up, with a nice intro article: Top 30 Features of SQL Server “Yukon”.