Turn Off Spell Check Sql Sever

SQL Server: Script to check/enable/disable ARITHABORT setting for the instance
  1. Turn Off Spell Check Sql Server Error Logs
  2. Turn Off Spell Check Sql Server Service Pack
Check sql server connection

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.

Turn
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

Sql server check locksSql
Sign up for freeto join this conversation on GitHub. Already have an account? Sign in to comment