Reverse Engineering of SQL Server System Tables causes warnings and errors

The errors in the Advisories show:

ESX-11556: Null Option is only valid for a parameter of natively compiled scalar function.

ESX-172429: Collation is not applicable for column with datatype sysname

Solution:

1. ESX-11556: Null Option is only valid for a parameter of a natively compiled scalar function
Details - Before sql2016 version, we couldn't set ‘Null’ as a parameter. But SQL Server 2016 introduced the natively compiled scalar function where we can assign NULL as a parameter.
So While Reverse Engineering of System Tables, somewhere if any function has defined the NULL parameter and if its type is not a natively compiled scalar function, in that case, the Semantic Error – 11556 is being displayed.

2. ESX-172429: Collation is not applicable for column with datatype sysname
If a column has a datatype ‘sysname’, collation is not supported.

These errors are valid.