tracing the objects created/modified by particular user.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » tracing the objects created/modified by...

tracing the objects created/modified by particular user.

Rate Topic

Display Mode

Topic Options

Author

Message

Joy Smith San

Posted Tuesday, October 21, 2008 5:27 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 7:35 PM
Points: 1,370, Visits: 2,290

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

steveb.

Posted Tuesday, October 21, 2008 6:35 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:42 AM
Points: 2,802, Visits: 7,103

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 »

Permissions