You can simply fire commit command , if you are using transactions in SQL. You can also use Autocommit to automatically commit the transaction when it is finished. This will not let you to fire commit command. You can find all the uncommited transactions through DBCC opentran; command.