---

This section details on the original issue you should resolve

<issue_title>Specify connection settings</issue_title>
<issue_description>Right now, the main difference between executing a query in SQL Query Stress and SSMS is that SQS does not have ARITHABORT enabled. Pictured below are a couple stored procedure executions from an SSMS tab, and then via SQS.

I understand why it behaves this way, but it would be nice to be able to specify connection settings like you can in SSMS, so things are a bit less wiggly if you're switching between the two.

SSMS options (Tools > Options > Query Execution > SQL Server)

ANSI:

Advanced:

Thank you</issue_description>

<agent_instructions>Proposed solution:

For the CommandText property below, read the contents of the querysettings.sql file

You can create an event handler for the Connection StateChange and have it set the property when the connection changes from Closed to Open as follows:

protected static void OnStateChange(object sender, StateChangeEventArgs args)
{
if (args.OriginalState == ConnectionState.Closed
&& args.CurrentState == ConnectionState.Open)
{
using (SqlCommand _Command = ((SqlConnection)sender).CreateCommand())
{
_Command.CommandType = CommandType.Text;
_Command.CommandText = "SET ARITHABORT ON;";

    _Command.ExecuteNonQuery();
}

}
}
With that in place, you only need to add the following to each place where you create a SqlConnection instance:

_Connection.StateChange += new StateChangeEventHandler(OnStateChange);</agent_instructions>

Comments on the Issue (you are @copilot in this section)

@ErikEJ @erikdarlingdata Could we start with a text file with just the settings baked in? (That would then be used with each connection) ? @ErikEJ https://dba.stackexchange.com/a/95090/9320 @ErikEJ @erikdarlingdata Cool, I will add the settings to each open connection next. @ErikEJ Actually. Let me ask Copilot for help.

@copilot

Proposed solution:

For the CommandText property below, read the contents of the querysettings.sql file

You can create an event handler for the Connection StateChange and have it set the property when the connection changes from Closed to Open as follows:

protected static void OnStateChange(object sender, StateChangeEventArgs args)
{
if (args.OriginalState == ConnectionState.Closed
&& args.CurrentState == ConnectionState.Open)
{
using (SqlCommand _Command = ((SqlConnection)sender).CreateCommand())
{
_Command.CommandType = CommandType.Text;
_Command.CommandText = "SET ARITHABORT ON;";

        _Command.ExecuteNonQuery();
    }
}

}
With that in place, you only need to add the following to each place where you create a SqlConnection instance:

_Connection.StateChange += new StateChangeEventHandler(OnStateChange);

@ErikEJ @copilot