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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Auditing and writing trigger for system tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-10 : 09:40:11
Gopi writes "Hi Team,
1) Is there a way by which one can audit query statement containing the text "Alter database.......".
I don't want to audit anything else but only this kind of statement.
(Third party tools are not welcome. Sorry. C2 auditing is not the option for us. )
2) Is there a way I can write a trigger on the system table view.

Please help. I appreciate it and Thanks in advance. Thanks to this Community and sponsers.
Best regards
Gopi"
   

- Advertisement -