Post reply

Where The Deleted Table values

  • April 30, 2006 at 5:37 am

    #112728

    If we delete the values from table

    where that values will be store

    in

    delete tabale

    in @delete table

  • April 30, 2006 at 8:23 pm

    #635056

    Check the books online in the trigger section. The only way you can access deleted data is in a trigger in the Deleted table. After that you need to use a log reader or a backup to regain access to the lost data.

  • April 30, 2006 at 11:57 pm

    #635057

    yes. within the delete trigger, it can be access from the deleted table.

    What is your requirement ? Do you need an audit trail of that table ?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply