DDL as part of a transaction

• Karim Hemani

  SSCrazy

  Points: 2063

  More actions

  December 19, 2005 at 9:21 am

  #111574

  Is DDL, such as index creation, also considered part of a transaction, or is a transaction only a sequence of DML operations? The reason why I ask is that in full recovery mode, the SQL SRVR logs index creation in the transaction log as well. If DDL isn't part of a transaction, then how come it is logged in the "transaction" log? Please clarify.

  Thanks a lot,

  Karim

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736578

  More actions

  December 19, 2005 at 9:55 am

  #610361

  Everything is part of a transaction. That is how the server can recover in between any crashes or reboots and maintain integrity.