Posted by Jens on 10/02/08 11:45

The log is the transactional heart of SQL Server. It guarantees
concistency over multiple transactions. If you don´t open a dedicated
one, the transaction you are working in is implicit, so every statement
that you issue will be executed right on hand. If you have a
transactional backup of your database you can do a point-in-time
recovery depending on your recovery model.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

[Back to original message]