Francisco Tapia
fhtapia at gmail.com
Mon Nov 1 23:15:34 CST 2004
if you set your transaction log to FULL logging, then ALL transactions are logged, the ones between the BEGIN and COMMIT / ROLLBACK are for being able to controll error handling but everything is LOGGED (when FULL logging is enabled). On Mon, 01 Nov 2004 23:06:35 -0500, John W. Colby <jwcolby at colbyconsulting.com> wrote: > Are all db changes recorded in transaction logs (if they are enabled) or > only statements between the begin and the commit / rollback? > > John W. Colby > www.ColbyConsulting.com > > Contribute your unused CPU cycles to a good cause: > http://folding.stanford.edu/ > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco <a href="http://pcthis.blogspot.com">Pc This! pc news with out the jargon</a>