Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

tracing the objects created/modified by particular user. Expand / Collapse
Posted Tuesday, October 21, 2008 5:27 AM


Group: General Forum Members
Last Login: Today @ 2:52 AM
Points: 1,995, Visits: 3,170
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.


Post #589068
Posted Tuesday, October 21, 2008 6:35 AM


Group: General Forum Members
Last Login: Monday, August 24, 2015 6:12 PM
Points: 2,808, Visits: 7,195
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.
Post #589097
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse