SQL Server 2012 Day 6

123456789
Across
  1. 3. A special mark inside a transaction that allows all commands that are executed after it to be rolled back to that point
  2. 4. Transaction requires defining the beginning and end of the transactions
  3. 6. Global variable that determine nesting level
  4. 8. Default type of trigger in SQL Server
  5. 9. Table that stores old values while execution of trigger
Down
  1. 1. Changes made on the data are made permanent
  2. 2. Transaction that automatically starts a new transaction after the current transaction is committed/rolled back
  3. 3. System stored procedure to specify order in which triggers will get fire
  4. 5. Clause with which trigger replaces the corresponding triggering action
  5. 7. A mechanism that is invoked when a particular action occurs on a particular table