Asger Blond
ab-mi at post3.tele.dk
Sat Sep 13 16:54:57 CDT 2008
>From http://support.microsoft.com/kb/272093 "In the full recovery model, every change to the database is logged." "In the Bulk-logged model, minimal logging may be performed for the following operations to save transaction log space: • Bulk load operations, including bcp and BULK INSERT. • CREATE INDEX, including indexed views. • SELECT INTO • WRITETEXT • UPDATETEXT • DTS with Use Fast Load and Table Lock enabled." Don't know if this is a comprehensive list. Asger -----Oprindelig meddelelse----- Fra: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Susan Harkins Sendt: 13. september 2008 21:44 Til: SQLList Emne: [dba-SQLServer] transactions not logged I'm looking for a comprehensive list of transactions not tracked and logged in the transaction log, but so far, no luck. If you have something bookmarked, please share. Susan H. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com