I encountered an issue while using Azure Synapse’s Lookup Activity to call a stored procedure that deletes records from a table. Despite the activity completing almost instantaneously, no records were deleted. Initially, I suspected that the problem might be related to permissions. However, the stored procedure sometimes works when triggered manually, but not always.