Turn Off Spell Check Sql Sever

Posted on by



Turn Off Spell Check Sql Sever

You may have seen that SQL Server Management Studio 2017 automatically bubbles and asks for updates. But your users do not have permission to install updates and you maintain updates via WSUS. SQL Server Management Studio 17.x is available via WSUS.

Aug 13, 2016 How to Turn On or Off Spelling Autocorrect and Highlight Misspelled Words in Windows 10 Windows 10 includes a spell checking feature for when you type words anywhere in Windows 10. When autocorrect misspelled words is turned on, it will autocorrect your typed words on the fly if matched with the correct spelling of the word in the dictionary. I was tasked yesterday with writing a spell checker for an up-and-coming application. I completed the meat of the functionality today, done in sql. It's actually very acurate, pulling most words within the first 15 suggestions, but many within the first 5.

Microsoft has for unknown reasons moved this setting into HKEY_CURRENT_USER. How stupid is this... Software is deployed per machine and not per user. Software is only deployed by idiots per user.

Now you have two options:

  1. Walk to every users and uncheck the Tools > Check for Updates > Automatically check for updates for SQL Server Management Studio setting. Not really an enterprise solution.
  2. Create a per User Group Policy and set the registry key. The value True (Default) enables and False disables the update notification.

The “sa” user is the default user created during the Microsoft SQL Server installation. You must always disable or rename the “sa” user before handing the system to the operation team.

So, how do you check if the “sa” user is renamed or disable.

Check Sql Server Version

Execute the following command line,

From the above screenshot, if the name is showing other than “sa”, it means the “sa” user has been renamed. In this example, it has been renamed to “opersys”. The “is_disabled” value 1 means that the user is in disabled state, means you cannot use this user to login.

Check Sql Server Connection

Alternatively, use below command (no disabled status will be shown)