Symptoms

Is it possible to execute a SQL stored procedure from a workflow? If so, how can you execute the stored procedure?
 

Diagnoses

There are numerous ways to action a stored procedure from a workflow. You could create a smartobject for the stored procedure, write custom code to execute the stored procedure, or many other creative solutions.
 

Resolution

You can execute SQL using a smartobject. Furthermore, in your workflow you can use a smartobject event to action it within your process. Here is a link regarding smartobject events.

http://help.k2.com/onlinehelp/k2blackpearl/userguide/4.6.8/webframe.html_Event - SmartObject Event Wizard.html