'KILL XXX WITH STATUS ONLY' gives error 'Incorrect syntax near 'STATUS'
But, we are having the same problem on two of our Synapse SQL Serverless environments. It happened before, but then after 24 hours they disappeared, they are in command 'KILLED/ROLLBACK' for days now and blocking new queries.