transactions

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  July 15, 2003 at 12:42 pm

  #83805

  I am not aware if we can we have a bulk insert statement where the transactions are not logged. Also how is it possible to have no transactions logged for an insert and update statment. any help will be greatly appreciated

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  July 15, 2003 at 1:18 pm

  #465587

  Any update and insert statements will be logged even though database is set as simple recovery mode.

  In order to minimize transaction being logged in BULK Insert, all following considitions have to be met.

  The recovery model is simple or bulk-logged.

  The target table is not being replicated.

  The target table does not have any triggers.

  The target table has either 0 rows or no indexes.

  The TABLOCK hint is specified