Better filter @IncludeMSShipped when @DbName is ALL

[jeffchulg]

Hi,

first of all, thanks for this tool.

After that, I tried following command:

sp_DBPermissions @Output = 'Report' , @IncludeMSShipped = 0, @DbName = 'ALL'

And it turns out there are missing filters :

Could you possibly add these filters ?

[sqlstudent144]

Yea, msdb is weird. It doesn't mark those roles as "ismsshipped". It's basically a user database used by MS.

Thanks,

Kenneth Fisher, Microsoft Data Platform MVP

www.sqlstudies.com http://www.sqlstudies.com

On Thu, May 11, 2023 at 2:55 AM Jefferson ELIAS @.***> wrote:

Hi,

first of all, thanks for this tool.

After that, I tried following command:

sp_DBPermissions @Output = 'Report' , @IncludeMSShipped = 0, @DbName = 'ALL'

And it turns out there are missing filters :

[image: image] https://user-images.githubusercontent.com/1788348/237612663-9a38aad0-21e1-42c0-992d-7e1794c45332.png

Could you possibly add these filters ?

— Reply to this email directly, view it on GitHub https://github.com/sqlstudent144/SQL-Server-Scripts/issues/21, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACZEU3EMM5EOH7624TGT7LDXFSLPFANCNFSM6AAAAAAX5XNPTI . You are receiving this because you are subscribed to this thread.Message ID: @.***>