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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2007-03-05 : 01:58:00
|
| Hi pals, I need one trigger for Auditing purpose.Currently we are using SQL Server 2005. I have gone thru some articles on DDL trigggers but iam not able to get good info.Frns, Need a trigger which can track all ddl's on all tables in the current database in an audit table. It should include dropping tables,altering tables ... I should'nt allowboth these activities. The action performed must be tracked in the following table. create table audit_ddl ( login_user varchar(20), login_time datetime, table_name varchar(50), action_performed varchar(200) -- Entire ALTER/DROP SQL stmt the user issued issued must be tracked here. )Can any senior DBA can help me out.Thanks & Regards,franky |
|
|
|
|
|
DDL trigger (urgent )