SQL Server: Script to check/enable/disable ARITHABORT setting for the instance
I'm am currently trying to disable spell check function in word through local gpo at local machine but i'm having no luck. I have disabled (admin template)Mark grammars errors as you type and check grammar with spelling. After disabling i ran gpudate /force and restarted the pc as well. I want to get rid of this red squiggly line. It is not possible to apply this setting on a single paragraph, as this option is not available.To turn off automatic spelling checking and automatic grammar checking, follow the given steps, as appropriate for your situation:1.Click the File tab, and then click Options.2.Click Proofing.3.Click to clear the Check spelling as you type check box.4.Click to clear the Mark grammar as you type check box.
ARITHABORT.sql
Turn Off Spell Check Sql Server Error Logs
/***************************************************************************/ |
/******************************TEST FOR ARITHABORT ON***********************/ |
/***************************************************************************/ |
DECLARE @options TABLE ([name] nvarchar(35), [minimum] int, [maximum] int, [config_value] int, [run_value] int); |
INSERTINTO @options ([name], [minimum], [maximum], [config_value], [run_value]) |
EXEC sp_configure 'user_options'; |
SELECT'ARITHABORT '+CASEWHEN ([config_value] & 64) =64THEN'ON'ELSE'OFF'END |
FROM @options; |
/***************************************************************************/ |
/******************************SET ARITHABORT ON****************************/ |
/***************************************************************************/ |
-- NOTE: By enabling this at the instance level all .net clients will automatically start connecting with using SET ARITHABORT ON |
DECLARE @options TABLE ([name] nvarchar(35), [minimum] int, [maximum] int, config_value] int, [run_value] int); |
DECLARE @Value INT; |
INSERTINTO @options ([name], [minimum], [maximum], [config_value], [run_value]) |
EXEC sp_configure 'user_options'; |
SELECT @Value = [config_value] | 64 |
FROM @options; |
EXEC sp_configure 'user_options', @Value; |
RECONFIGURE; |
SELECT*FROM @options; -- prior state |
EXEC sp_configure 'user_options'; -- current state |
/***************************************************************************/ |
/******************************SET ARITHABORT OFF***************************/ |
/***************************************************************************/ |
DECLARE @options TABLE ([name] nvarchar(35), [minimum] int, [maximum] int, [config_value] int, [run_value] int); |
DECLARE @Value INT; |
INSERTINTO @options ([name], [minimum], [maximum], [config_value], [run_value]) |
EXEC sp_configure 'user_options'; |
SELECT @Value = [config_value] & ~64 |
FROM @options; |
EXEC sp_configure 'user_options', @Value; |
RECONFIGURE; |
SELECT*FROM @options; -- prior state |
EXEC sp_configure 'user_options'; -- current state |
Turn Off Spell Check Sql Server Service Pack
Sign up for freeto join this conversation on GitHub. Already have an account? Sign in to comment