Query to find out the user who changed the table Name

Question

Query to find out the user who changed the table Name

adilahmed1989

Right there with Babe

Points: 739
More actions
October 9, 2017 at 1:21 am

#340597

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
August 2, 2018 at 7:39 pm

This was removed by the editor as SPAM
August 2, 2018 at 7:39 pm

This was removed by the editor as SPAM
August 2, 2018 at 7:40 pm

This was removed by the editor as SPAM

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

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

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: 736430 More actions · Answer 2

This may help you to query the default trace: http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

adilahmed1989 Right there with Babe Points: 739 More actions · Answer 3

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

Regards,
Adil