Set arithabort ON When executing a command from powerbuilder application

Question

Script to Set arithabort ON When executing a command from powerbuilder application once session logon.

Answer 1

Not clear, what you are exectly looking for.

Add "Set arithabort ON" to your SQL scripts.

Answer 2

Hello there,

There is no setting to force SqlClient to always set ARITHABORT on, you have to set this as you describe.

You should always set ARITHABORT to ON in your logon sessions. Setting ARITHABORT to OFF can negatively impact query optimization leading to performance issues. https://learn.microsoft.com/en-us/sql/t-sql/statements/set-arithabort-transact-sql?redirectedfrom=MSDN&view=sql-server-ver16

The default ARITHABORT setting for SQL Server Management Studio is ON. Client applications setting ARITHABORT to OFF might receive different query plans, making it difficult to troubleshoot poorly performing queries.

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–

Answer 3

Hello there,

There is no setting to force SqlClient to always set ARITHABORT on, you have to set this as you describe.

You should always set ARITHABORT to ON in your logon sessions. Setting ARITHABORT to OFF can negatively impact query optimization leading to performance issues. https://learn.microsoft.com/en-us/sql/t-sql/statements/set-arithabort-transact-sql?redirectedfrom=MSDN&view=sql-server-ver16

The default ARITHABORT setting for SQL Server Management Studio is ON. Client applications setting ARITHABORT to OFF might receive different query plans, making it difficult to troubleshoot poorly performing queries.

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–

Answer 4

Your question (or whatever we should call it) is not really clear.

But in any case, the setting ARITHABORT has absolutely no effect, if other SET options are in their default positions, so there is no reason to meddle with it.