I am trying to get my Zap to execute a stored procedure on a remote SQL Server. The stored procedure stores a new row in a table using a list of parameters.
Everything works fine - except that I can’t get to commit the transaction.
I can execute the SP using the “Find Row via Custom Query in SQL Server” function in my Zap, but it doesn’t commit. It connects, and works, since I get a return value that has the correct new row ID, but the transaction is never committed.
The query in my zap looks like this:
EXEC MyStoredProc Param1, Param2……
but it never commits.
Is this perhaps because the whole Zap function is a read-only transaction? - wouldn’t I get an error message then?
Is there any other way of achieving what I’m trying to do?
Best answer by satya
Here is how I solved this issue. By default the connection is executing query by setting implicit transaction mode to ON. I turned off implicit transactions and removed transaction in zapier query window.