Post reply

DELETED table

  • March 27, 2012 at 4:37 am

    #255401

    Hello,

    I am using a delete trigger to keep a track of records getting deleted from one of my application tables. I want to know, in which database does SQL Server creates the DELETED table??

    Thanks,

    Nisha

  • March 27, 2012 at 4:41 am

    #1464851

    they live in memory for the scope of the transaction, they are not created in a database

  • March 27, 2012 at 5:10 am

    #1464873

    It's materialised from the row version store, so it will be in memory, spill to TempDB if necessary.

    Where it is is not important though, it is just referenced by the name 'deleted' within a trigger.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 27, 2012 at 6:48 am

    #1464938

    In the Creation table we can create a trigger on table.then easily we will know

  • March 27, 2012 at 7:42 am

    #1464979

    Div Goud (3/27/2012)

    In the Creation table we can create a trigger on table.then easily we will know

    What??

Viewing 5 posts - 1 through 4 (of 4 total)

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