All geek questions in one place

IntelliSense not working in SQL Server Management Studio

We are using SQL Server Management Studio 2008 R2. IntelliSense works great with an SA account. But it does not work with windows authentication user. The user has access to the main database with the db_owner role, but this is not sysadmin.

How can I fix this problem?

+15
source share
12 answers

You can try to solve these questions1 or questions2 and questions3 .
Or please try these steps as shown below:

  • Enable IntelliSense:
    • For all query windows, go to Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense and select Enable IntelliSense.
    • For each query window that opens, go to Query >> Intellisense Enabled.
  • Enable statement completion: go to Tools >> Options >> Text Editor >> Transact-SQL >> General and select the check boxes in the "Auto List" and "Options" elements.
  • Update the IntelliSense local cache: go to >> Modify >> IntelliSense >> Update the local cache or use the CTRL + Shift + R key combination to update.
  • Wait a minute or two for the update to complete and try again.
+19
source

This may seem like a too short answer, but maybe this is the solution to your problem:

CTRL+SHIFT+R

Also, I found this: IntelliSense Troubleshooting (SQL Server Management Studio)

+11
source

I had the same problem. Everything was included to provide the correct Intellisense features, but did not work. I realized that SQLCMD mode is enabled by default. Disabling restored Intellisense functionality :)

+5
source

Increasing the maximum script size in the Tools, Options, Text Editor, Transact-SQL, IntelliSense menus fixed Intellisense for me.

+2
source

Missing from other solutions, but fixed for me:

 Edit > IntelliSense > Toggle Completion Mode

or CTRL + ALT + Space

+1
source

I found a solution at the end. I installed SQL2008 R2 SP3.

0
source

It may also depend on your destination server.

For example, for server 2005, intellisense will not work. Here is the command to test this:

 SELECT SERVERPROPERTY('ProductVersion');

If the version starts with 8 or 9, it will not work .

More info for: problem with sql server intellisense here

A workaround could be to use the SQL Server plugin as an express version autocomplete

0
source

After installing Visual Studio or updating it, this problem can occur at the link: what is the IntelliSense problem in sqI ntelliSense, and to solve this problem you can do the following: upgrade the sql server , updating it to the latest version, and you will get your solution.

0
source
  • If the automatic participant list items and parameter information fields are enabled, disable them, and then click OK. After the operation, turn on the blocks again and press the OK button.
  • If the automatic list items and parameter information fields are disabled, enable them, and then click OK.
0
source

My circuits were too big. I had to do this:

Tools >> Options >> Text Editor >> Transact-SQL >> Intellect

Maximum script size: unlimited

0
source

If you see your text in red and have several statements, this may be due to a missing quote. Or a bad syntax check. Try entering a quote at the end. Then Intellisense should re-enter your next statement.

0
source

Turning Query> SQLCMD Mode on and off again fixed the issue for me in SSMS 18.1, although it was never turned on from the start.

After trying all the answers here to no avail and giving up , I was still interested in the SQLCMD mode mentioned in the Chow Lover answer. I turned it on to see what he did, but did not notice any changes, so turned it off again. Intellisense woke up suddenly and has been working fine ever since.

0
source

Source: https://habr.com/ru/post/1014318/

More articles:


All Articles