Any way to see who modified a table

• thecodeguys

  Ten Centuries

  Points: 1076

  More actions

  March 13, 2009 at 4:13 pm

  #132246

  Is there any way to find out who may have altered a table without a DDL trigger? I doubt it, but I just wasn't sure if there was a view somewhere in SQL 2005.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  March 13, 2009 at 4:22 pm

  #959540

  http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

• JeremyE

  SSCoach

  Points: 16200

  More actions

  March 13, 2009 at 4:26 pm

  #959542

  There is a default trace running which will give you the info if it happened recently. Right click on the database, Reports, Standard Reports, Schema Changes History.

  If I remember correctly you have to have SP2 installed.

• thecodeguys

  Ten Centuries

  Points: 1076

  More actions

  March 13, 2009 at 5:13 pm

  #959574

  Thanks a TON. You just saved me a ton of work.