No ratings

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


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.






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

Labels: (3)
Version history
Last update:
‎06-22-2021 01:54 PM
Updated by: