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.