如何在表-SQL Server上设置自动提交

I have a stored procedure where I need to commit only ERROR_LOG table, if any error or if we are terminating the procedure in between any process. And in this scenario all other changes has to be rolled back except ERROR_LOG table insertion.I have a stored procedure where I need to commi