There is a lot of info in the MSKB, set product name to SQL Server and Search for... to Transaction Rollback
>Hi Guys, >What happens when a user reeboots their computer or uses the task manager to termintae a client VFp program that is in the middle of a transaction ? Does it retains locks on tables or rows ? what happens to those transactions ? >is there a command where I roll back when i am online again or from the Sql server query analyser ? > > >TIA