How to invoke a stored procedure
I wanted to execute a stored procedure from the workflow as its first activity. My credential has the required permission to execute the stored procedure which is created on SQL Server DB. The stored procedure takes care of creating a new entry to the log table with the information such as start time, 'Started' as the status; and it returns the Log Id of the newly inserted record, so this Log Id can be used in subsequent activities. Also, I wanted to execute another procedure as the last activity in my workflow, which takes care of updating the status as 'Completed' and current time as End Time for the Log Id which we generated at the beginning.