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: 112214

    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.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 716661

  • adilahmed1989

    Mr or Mrs. 500

    Points: 599

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

    Regards,
    Adil

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

  • This was removed by the editor as SPAM

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

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