tracing the objects created/modified by particular user.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  October 21, 2008 at 5:27 am

  #194779

  Dear All,

  I have created a seperate login id for my developers. I have given all the rights for that login id, even though they are not supposed to create Procs & tables in DB. Now I want to trace the procedures and tables created/modified by that particuar login id. (if possible it's date & time tooo).

  Can anyone guide me how can I get those details......

  thanks in advance.

  Santhu...

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  October 21, 2008 at 6:35 am

  #887550

  You can get this information from the Schema Changes report that is part of the default trace on sql 2005.

  Right click on the db in SSMS --> Reports.

  Or else you can create DDL triggers on the CREATE events and use these to record the information needed in a table.