如何永久地应用SET ARITHABORT OFF？ [英] how to apply SET ARITHABORT OFF permanently?

问题描述

如何申请

how to apply

SET ARITHABORT OFF
SET ANSI_WARNINGS OFF

永久？



当我在sql server中执行这些语句时，它只为当前会话提供结果，

我想要工作这些永久声明。我该怎么做？



先谢谢你。

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.

推荐答案

据我所知，你不能永久地设置它，即使是在逐个数据库的基础上（当然，ALTER DATABASE语句不会将它列为一个选项： http://msdn.microsoft.com/en-us/library/bb522682.aspx [ ^ ]）你绝对不应该尝试为SQL Server实例设置它，因为它会有一个负数所有数据库的性能，而不仅仅是你的： http://msdn.microsoft.com/en-us/ library / ms190306.aspx [ ^ ]



这是基于连接的设置，原因是：它对性能有很大影响，应该根本不设置为OFF！ ：笑：



为什么不只是检查你的值？

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?

你可以在中设置它ALTER DATABASE 声明（参见 Technet：ALTER DATABASE SET选项（Transact-SQL） [ ^ ]）。

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

这篇关于如何永久地应用SET ARITHABORT OFF？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！