| 
 Posted by Jens on 06/19/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 
---
 
  
Navigation:
[Reply to this message] 
 |