locked
How to findout who made and what changes made to the table RRS feed

  • Question

  • One of the users renamed the name of the table in Development server. Now i want to know which user has done that. And i have not run the profiler also by that time.Triggers also not created on that table how can i troubleshoot?
    Ramesh.M
    Tuesday, June 28, 2011 12:59 PM

Answers

  • Hi,

     

    Without running the profiler or having a trigger you are not able to detect who changed the name of the table.

     

    Kevin

    • Marked as answer by Stephanie Lv Wednesday, July 6, 2011 9:32 AM
    Tuesday, June 28, 2011 1:57 PM
  • The default trace should be running as it's enabled by default. If that instance hasn't been restarted or hasn't been extremely busy you may be able to extract the inforamtion from it. Please refer to SQLUSA's post about this: http://www.sqlusa.com/bestpractices/default-trace/

    -Sean

    • Marked as answer by Stephanie Lv Wednesday, July 6, 2011 9:33 AM
    Tuesday, June 28, 2011 3:18 PM
  • Notice that the default trace (provided it is running) is a feature of SQL Server 2005 forward, which likely includes your SQL Server installation. 

    In addition to reading the trace directly, which Sean Gallardy mentioned, there is also a standard report.  Right click on the SQL Server name in SSMS Object Explorer and choose  Reports \ Standard Reports \ Schema Changes History. 

    However, if you are still running SQL Server 2000 or earlier, this feature does not exist and you have no recourse to figuring out who did it.  Except the standard social methods of checking around, seeing whose code was changed to support the new name, looking into your source control database (if you have one), and so forth.

    RLF

    • Marked as answer by Stephanie Lv Wednesday, July 6, 2011 9:33 AM
    Wednesday, June 29, 2011 5:18 PM
  • If you are using Enterprise Edition of SQL Server 2008 and later, you can use the Audit feature to track changes done to any object in the database.

    • Marked as answer by Stephanie Lv Wednesday, July 6, 2011 9:34 AM
    Friday, July 1, 2011 4:37 PM

All replies

  • Hi,

     

    Without running the profiler or having a trigger you are not able to detect who changed the name of the table.

     

    Kevin

    • Marked as answer by Stephanie Lv Wednesday, July 6, 2011 9:32 AM
    Tuesday, June 28, 2011 1:57 PM
  • The default trace should be running as it's enabled by default. If that instance hasn't been restarted or hasn't been extremely busy you may be able to extract the inforamtion from it. Please refer to SQLUSA's post about this: http://www.sqlusa.com/bestpractices/default-trace/

    -Sean

    • Marked as answer by Stephanie Lv Wednesday, July 6, 2011 9:33 AM
    Tuesday, June 28, 2011 3:18 PM
  • Notice that the default trace (provided it is running) is a feature of SQL Server 2005 forward, which likely includes your SQL Server installation. 

    In addition to reading the trace directly, which Sean Gallardy mentioned, there is also a standard report.  Right click on the SQL Server name in SSMS Object Explorer and choose  Reports \ Standard Reports \ Schema Changes History. 

    However, if you are still running SQL Server 2000 or earlier, this feature does not exist and you have no recourse to figuring out who did it.  Except the standard social methods of checking around, seeing whose code was changed to support the new name, looking into your source control database (if you have one), and so forth.

    RLF

    • Marked as answer by Stephanie Lv Wednesday, July 6, 2011 9:33 AM
    Wednesday, June 29, 2011 5:18 PM
  • If you are using Enterprise Edition of SQL Server 2008 and later, you can use the Audit feature to track changes done to any object in the database.

    • Marked as answer by Stephanie Lv Wednesday, July 6, 2011 9:34 AM
    Friday, July 1, 2011 4:37 PM