>what if the connection is broken and you can no longer communicate with the SQL Server from the client. I would be unable to issue any further commands What will happen to the records i was adding or updating ???
>
>Chris
If the transaction is not committed, then SS never truly updates the rows. If the connection is severed before a commit is done, SS will perform a rollback.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao