how to apply SET ARITHABORT OFF permanently?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

, +

how to apply

VB

SET ARITHABORT OFF
SET ANSI_WARNINGS OFF

permanently?

when i executes these statements in sql server it gives result for current session only,
I want to work these statements permanently. How I should do this?

Thank you in Advance.

Posted 15-Jan-15 0:33am

Sid_Joshi

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-01-15T00:45:00

As far as I know, you can't "set it permanently", even on a database-by-database basis (certainly, the ALTER DATABASE statement doesn't list it as an option: http://msdn.microsoft.com/en-us/library/bb522682.aspx[^]) and you should definitly not try to set it for a SQL Server instance, as it will have a negative on performance for all databases, not just yours: http://msdn.microsoft.com/en-us/library/ms190306.aspx[^]

It's a connection based setting for a reason: it has a big impact on performance and shouldn't be set to OFF at all! :laugh:

Why not just check your values instead?

CPallini · Answer 2 · 2015-01-15T00:45:00

Solution 2

You may set it in the ALTER DATABASE statement (see Technet: "ALTER DATABASE SET Options (Transact-SQL)"[^]).

Posted 15-Jan-15 0:45am

CPallini

Comments

Sid_Joshi 15-Jan-15 7:04am

still It doesn't work.