No nothing happens the changes that where made on that transaction will not be present on the database once sql server comes back up.
>>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>
Alexandre Palma
Senior Application Architect