No ratings

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.

 

MTMTNT_0-1624395004927.png

 

 

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.

 

MTMTNT_2-1624395269091.png

 


 

 

Related Links

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