Accessing a table in tempdb

  • We have a vendor financial database that uses an internal process to create a temp table in tempdb at a certain point. The application gives prompts along the way after each step so when we get to the point the table is created we can see it, but can't select from it. It's a local temp table...We want to be able to stop at time it's created, which we can do and then run a query against to pull some of the info. Has anyone ever done this or does anyone have any ideas of how to access the data? Thanks in advance!

    Thanks!

  • I guess you're looking for this:

    Viewing Another Session’s Temporary Table

    Hope this helps

    Gianluca

    -- Gianluca Sartori

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

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