1
Vote

Unable to turn off all but 1 result set

description

With the command below I get two result sets, it would be great to only get one as shown in attached image.
exec SSISReportingPack..sp_ssiscatalog
                @exec_warnings=0, 
                @exec_events=0,
                @exec_execution=0,
                @exec_executable_stats=1
Thanks

Martin

file attachments

comments

SurbitonBoy wrote Nov 8, 2013 at 12:37 PM

Ah user error didn't see the exec errors parameter.
exec SSISReportingPack..sp_ssiscatalog
        @exec_errors=0,
                @exec_warnings=0, 
                @exec_events=0,
                @exec_execution=0,
                @exec_executable_stats=1

jamiet wrote Nov 8, 2013 at 1:42 PM

ahh bonzer. I was about to look into this before I saw the second email. Good news.