You’re offline. This is a read only version of the page.
This error came up for me when I was trying to create my power automate flow:
Microsoft SQL: The target table 'dbo.F406' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause. inner exception: Microsoft SQL: The target table 'dbo.F406' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause. clientRequestId: ea751c6b-1edc-4cf6-a0fa-b373d6fc2823
What does this mean and how can I fix it? Will I need to fix this in SQL, Power Automate or both?
@Anonymous
This would do better in the SQL Side. From the Flow side, it doesn't care what you make the SQL Query, so you would need help creating the correct query and then use that in flow.
I would post here Welcome to the SQL Server Community (microsoft.com)
If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Share
Report
All responses (
Answers (
53,928
