>And by the way, if you unplug a SQL server in the middle of a transaction, I guess it also will cause some strange behavior.

hm..., my guess is you wont't, especially not when it is in a transaction.
But its just a guess, someone should make some tests. <bg>