Forum Discussion

SharePointAdmin1030's avatar
SharePointAdmin1030
Copper Contributor
Sep 22, 2025

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

Resources