Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2003
    Posts
    84

    Unanswered: Temporary tables

    How can I view logs of local (to a session) temporary that are created/dropped?

  2. #2
    Join Date
    Oct 2003
    Posts
    84
    TYPO

    How can I view logs of local temporary tables that are created/dropped?
    (Local meaning to a session, created using #MyTableName).

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Do you mean the transaction log?

    You've lost me on this one....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Oct 2003
    Posts
    84
    Yeah (I seem to always lose people when I post something)

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Is that you want to know when the tables rae being created and dropped?

    To look in to a trans log you, the only thing I know is lumigent log explorer



    Log Explorer
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Sep 2003
    Posts
    522
    you can create a custom trace script (go to profiler, configure filters, events, columns, etc., and save it as a script) and convert it to a procedure. you can also set this procedure as a startup. the results of the trace can be dumped into a table for ease of search later on.

  7. #7
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    When you setup your trace, only specify DatabaseID 2 as the filter (this is tempdb) and use only Objects -- Object:Created and Objects -- Objecteleted for your events.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •