I know you can use SET XACT_ABOT ON to set up auto rollback on MS SQL Server. My question is how to have the sql server turn this feauture on every time it starts. Thanks in advance.