I would like to write a stored proc.
and update a table in the stored proc.
and there is a trigger on that table to log the process.
No matter the stored proc is successed or failed.
the Log should be commited.
How to rollback back the stored proc updated data but commit the log written by the trigger.