Forum Discussion
SharePointAdmin1030
Sep 22, 2025Copper Contributor
Azure SQL server rollback itself?
We have an Azure SQL server. It is a datasource of a Power App canvas app.
Today I connected to it with SSMS v19.
First, I ran 'Begin tran' twice (is it a mistake?).
Then 'Delete From dbo.table1 where ID=30' and another row with ID=31.
Then I verified these 2 rows are deleted by 'Select * from dbo.table1'
Finally, I ran 'Commit tran'
I verified again above 2 rows are deleted by 'Select * from dbo.table1'
However, there is no change in the Power App.
So I reopen the SSMS and connect to the DB again. This time when I ran 'Select * from dbo.table1', the 2 rows are showing up.
What could be the problem? Is it a bug in old version SSMS?
No RepliesBe the first to reply