SQL Stored Procedure Only Allowing Execute Method

 

Symptoms

When attempting to create a SmartObject based off of a SQL Stored Procedure, there is only an Execute Method available.
 

Diagnoses

This issue is based on the K2 Service Account not having adequate permissions to the applicable server.
 

Resolution

Providing the correct permissions to the server for the K2 Service Account resolved the issue.