Post reply

Followup question to the trigger

  • September 20, 2018 at 10:16 am

    #363718

    I believe the results of the execution of my trigger are stored in temp table in temp db. because every time it runs it makes one of these #BFE88294.
    But I can not select from it. How can I query the contents of this table.
    Thank you

  • September 20, 2018 at 10:24 am

    #2006452

    As it is a local temporary table and it is apparently created in the trigger (we don't have the code for the entire trigger so have to assume), once the trigger is completed the table goes out of scope and you can't query it.

  • September 20, 2018 at 10:30 am

    #2006453

    Lynn Pettis - Thursday, September 20, 2018 10:24 AM

    As it is a local temporary table and it is apparently created in the trigger (we don't have the code for the entire trigger so have to assume), once the trigger is completed the table goes out of scope and you can't query it.

    Okay that is what I thought
    Thanks

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

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