Launch the SQL Server Configuration Manager. Double click on SQL Server Services. From the left panel, right click on your server instance and select Properties.
Go to Startup Parameters and add the new parameter. In this example, we are adding -T617 parameter. Click on Add, Apply and OK to apply the changes.
Next, you need to restart your SQL server instance to activate changes.
To verify the changes, use the following command,
DBCC TRACESTATUS
To disable the trace flag, you can select the parameter and click on Remove. Restart your server instance to apply and activate the changes.
Note:
For SQL Server running on Windows cluster, the trace flags need only to be apply to the active Node. The trace flags will be automatically replicated to the other nodes whenever SQL Server is started on those nodes.
