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 2008 Forums
 SQL Server Administration (2008)
 Auditing overheads

Author  Topic 

gedda
Starting Member

1 Post

Posted - 2011-06-09 : 01:15:24
I am wondering if someone can let me know about the fors/against using the sys.fn_get_audit_file function in comparison to using a trigger getting EVENTDATA() information for auditing puposes on DDL transactions.

Specifically, what I am after is does one have more overheads than the other or is one a more preferred method.

   

- Advertisement -