A Stored Procedure with Optional Parameters are showing as Required in the SmartObject

Issue

In SQL a Stored Procedure with optional parameters are showing Required when passing the value into the SmartObject method. 

Error Code

There is no error, but this is not expected behavior. See below.

Resolution

Double check that the account that is configured for Authentication in the SQL Server Service Instance has View rights to the Stored Procedure and Table(s) being called by the Stored Procedure. See below screenshot of SQL Server Management Studio.

Related Links

https://help.nintex.com/en-us/k2five/userguide/5.4/default.htm#ServiceBrokers/SQLServer/SQL-Server-Service.htm?TocPath=Administer%257CK2%2520Management%257CIntegration%257CService%2520Types%257CSQL%2520Server%257C_____0