Post reply

How to check or how do I know who has renamed a table on Prod server

  • August 28, 2014 at 11:55 am

    #292806

    hi DBAs,

    how do I know who has renamed a table on Prod server.

    here I can check the modified_date of the table from the sys.tables , but how do I know Which user has renamed the table...

    replys always appreciated. cheers..

  • August 28, 2014 at 12:07 pm

    #1741709

    I don't know for sure because I haven't used it in about 3 years but that kind of information might be in the default trace file. I know that table drops end up showing up there.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 29, 2014 at 8:16 am

    #1741919

    Jeff Moden (8/28/2014)

    I don't know for sure because I haven't used it in about 3 years but that kind of information might be in the default trace file. I know that table drops end up showing up there.

    It is in there as an Object:Altered event and the ObjectName is filled in with the original name. Just remember the Default Trace only has 100MB of data so, depending on how busy your server is, the event may have aged out of the trace.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

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

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