Post reply

Query to find the user who changed the name of table of a database

  • October 9, 2017 at 1:28 am

    #328962

    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

  • October 9, 2017 at 1:44 am

    #1962786

    adilahmed1989 - Monday, October 9, 2017 1:28 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

    Please do not cross post. https://www.sqlservercentral.com/Forums/1901423/Query-to-find-out-the-user-who-changed-the-table-Name

    As stated on the other topic, unless you have auditing check the default trace, otherwise you wont be able to find out.

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

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