free_mascot (7/18/2008)
You can't recover deleted rows unless and untill you are using checkpoint.
Checkpoints happen automatically and just write dirty data pages to disk. It's BEGIN TRANSACTION that allows data modifications to be rolled back.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability