As I make changes to an application I'm reminded how ugly @@IDENTITY is. We're using triggers to add some rudimentary data synchronization to this application. The application inserts a record, we capture it in the trigger and go put a copy in the new table. Except that the trigger sets a new value for @@IDENTITY when it fires. So our quick changes that weren't going to affect anything are now much bigger than we planned. Rather than doing this all at the database level we now have to open up the application and touch that code too. Or find a whole different approach.
This is a companion discussion topic for the original entry at http://billg.sqlteam.com/2003/09/26/173/