Stored procedure question within a transaction scope.

• davidsalazar01

  SSCarpal Tunnel

  Points: 4072

  More actions

  November 20, 2009 at 12:35 pm

  #140195

  😀 Hello,

  If you have the same stored procedure executed from 2 different web UI's at the same time and one of them opened a transaction scope (.NET) and started by the chain by deleting a record and then followed by inserting a record, etc,. Is it possible to see what record was deleted on the 1st step before the transaction scope is closed or committed?

  Thanks,

  David

• GSquared

  SSC Guru

  Points: 260824

  More actions

  November 20, 2009 at 12:38 pm

  #1082434

  You could use the output clause to create a recordset of the deleted record(s).

  Look up "Output" in Books Online, it has all the details.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon