Updated the script to make it work with SQL Server 2019

Thank You all for the initial code. It helped me a lot and saved a lot of time, too.

I can...

• This reply was modified 4 years, 1 month ago by  wegener.

Hi I just tried this usefull function unter SQL 2014.

In order to maked it run again i needed to replace

permissions(id)

with

(SELECT COUNT(*) FROM fn_my_permissions(id, 'DATABASE'))

because permissions is marked as...