Scripting Audits using SQL Server SMO does not script filters - by crazy1bryan

Status : 


Sign in
to vote
ID 793538 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/11/2013 10:05:31 AM
Access Restriction Public


I have created a Powershell script to script out many of our SQL Server 2012 objects and settings using SQL Server Management Objects namespace (Microsoft.SqlServer.Management.Smo.Server). When scripting out Audits, the script does not include filters.
Sign in to post a comment.
Posted by Microsoft on 7/29/2013 at 10:54 AM
Hello Bryan. Thank you for reporting this problem to us. However, we have been unable to reproduce the behavior locally using SSMS 2012. We recommend you try this scenario again with a clean installation of SSMS 2012, updated to SP1. We will be closing the issue as a “no repro.” If a fresh installation of SSMS 2012 still faces this issue, please get back in touch with us and we will assist you.

-Walter A Jokiel, Program Manager, SQL Server (
Posted by Sethu Srinivasan on 7/15/2013 at 11:56 AM
Can you please update to SQL 2012 SP1 and let us know if you still see this issue?

Microsoft® SQL Server® 2012 Service Pack 1 (SP1) -

Sethu Srinivasan [MSFT]
SQL Server