What happen if i forgot to give Commit transaction after begin trans?
Posted on 2012-03-30
I update the table along with Begin trans in the sql Query window and forgot to give commit trans and close the Query window. Can you please tell what happens?
Update DBName..tablename set name ='xxx' where name='yyy'
1. The Specific database locked and no other user access the database/Table?
2. whatever updated rollback automatically
3, What happen if i open new sql query window and give commit transaction after 2 to 3 hours.
4. And how to find out if someone forgot to give commit transaction after Begin Trans.
Please clarify me. Thanks.