DEP018
Published 20 November 2017
ALL option in GRANT/DENY/REVOKE statement is deprecated
The ALL keyword is highly confusing as it doesn’t add all permissions. It is legacy code that hasn’t kept pace with new versions of SQL Server. Don’t use it!