Hi Guys,
What happens when a user reeboots their computer

Normally SQL Server release the session ( after a little time ) and do a ROLLBACK.
But this (ill-fatedly) is not guaranteed 100%!


or uses the task manager to termintae a client Visual
FoxPro program that is in the middle of a transaction ?


This is more complex, because on VFP exist a serious bug:
if VFP not complete the quit process, and never SQLDISCONN() is done
the process is like a PC reset.
if you use DB_TRANSAUTO and VFP complete the quit process, it close the session and SQL do a ROLLBACK.
If you use DB_TRANSMANUAL and VFP complete the quit process, it send a COMMIT !


Does it retains locks on tables or rows ?
what happens to those transactions ?


Read previous.


is there a command where I roll back when i am online again or from the Sql server query analyser ?

sp_lock
KILL spid for release the zombi session spid ( SQL do a ROLLBACK )