It could be related to usage limit of Azure SQL database too.
Just for testing purpose, can you please increase the compute size of the database and run the code again?
Also is the for each in parallel execution?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi Team,
I am trying to execute few procs in my azure synapse workspace using lookup and forEach loop. While few of my procs are running fine without any errors in few I am getting "The connection is closed by SQL Database." error.
I executed those procs in ssms and they seems to be running fine without any error message. Could you guys please help me out to sort this one out.
It could be related to usage limit of Azure SQL database too.
Just for testing purpose, can you please increase the compute size of the database and run the code again?
Also is the for each in parallel execution?
Hi Team,
Thank you for the suggestion. I tried increasing the compute size of the database. It is working fine now.
I will be monitoring the same for few more days.
Thank You.