Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dev@nlkss
134 Posts |
 Posted - 2009-02-20 : 06:29:17
|
| AS a DBA i want to audit and trace an event when any new database object is created or any existing object is droped or modified.What is the best way to do it.Satya |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-02-20 : 06:32:18
|
| SQL Profiler (part of 2005 tools)There is a trace option for Objects: Object:Altered / Created / DestroyedIf you have the trace limited only to this then the overhead should be minimal.Still probably don't want to do this on production but these kind of events shouldn't be happening on production without your concent anyway.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-20 : 06:57:36
|
quote:
Originally posted by satya@imi
AS a DBA i want to audit and trace an event when any new database object is created or any existing object is droped or modified.What is the best way to do it.Satya
See Standard Reports in SQL 2005 for Schema Changes. It has detailed information for Who did it and What was changed and When it was changed. |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2009-02-25 : 14:53:21
|
| MOM or SQL Server 2k8 |
|
|
|
|
|
|
SQL DBA