[dba-SQLServer] Cancel INSERT?

I was really thinking of something more automated like an .Undo. :) 

Susan H. 

@@ Identity may problematic as this variable will contain the last insert
from anybody, using Scope_Identity() may be a better solution as it gives
you the last id used in your session.  If however the insert has ran and now
you want to lookup what you did because you need to roll it back you can do
it manually with software from quest software or idera


>
> > I know I can wrap INSERT in a transaction. Barring a transaction 
> > that
> keeps
> > the action from being committed, is there anyway to undo an INSERT
> action
> > that's been committed?