Home Dashboard Directory Help
Search

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


Status: 

Closed


1
0
Sign in
to vote
Type: Bug
ID: 793538
Opened: 7/11/2013 10:05:31 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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.
Details
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 (wajokiel@microsoft.com)
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) - http://www.microsoft.com/en-us/download/details.aspx?id=35575


Thanks
Sethu Srinivasan [MSFT]
SQL Server
Sign in to post a workaround.