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.
Comments
0 comments
Please sign in to leave a comment.