Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Tuesday, October 21, 2008 5:27 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:01 AM
Points: 1,557, Visits: 2,613
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...






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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
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