Query to find out the user who changed the table Name

  • adilahmed1989

    Mr or Mrs. 500

    Points: 599

    Dear All,
    Kindly guide me to find out  the user who had changed the name of table of a database.
    Basically I have got the date and time on which the table name was modified; however I would need to determine the user-name who had modified the name of table.
    This Table is critical as there is a job and SSIS package related to the table.

    Regards,
    Adil

  • anthony.green

    SSC Guru

    Points: 112212

    adilahmed1989 - Monday, October 9, 2017 1:21 AM

    Dear All,
    Kindly guide me to find out  the user who had changed the name of table of a database.
    Basically I have got the date and time on which the table name was modified; however I would need to determine the user-name who had modified the name of table.
    This Table is critical as there is a job and SSIS package related to the table.

    Regards,
    Adil

    Unless you have auditing in place, you will need to check the default trace, but the default trace only stores so much information so you may have lost the required details if your server is a very active one.



    How to post data/code for the best help - Jeff Moden[/url]
    Need a string splitter, try this - Jeff Moden[/url]
    How to post performance problems - Gail Shaw[/url]
    Managing Transaction Logs - Gail Shaw[/url]
    Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger[/url]

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714093

  • adilahmed1989

    Mr or Mrs. 500

    Points: 599

    Thanks for the article ; will let know if need any assistance.

    Regards,
    Adil

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

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