Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

SQL Server 2008 R2 intellisense not working

Tags:

sql-server

Just started a new job and everything was already installed on my machine. It's not exactly a friendly bunch. (early days)

I have SQL Server 2008 R2 and I see I have Visual Studio 2010 SP1.

I don't have any intellisense in SQL Server Management Studio.

Googled and found hundreds of hits!!!

Ultimately I have found this link:

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2507770&kbln=en-us#step1

The problem is I have so many hotfixes to choose from and I don't know which one Do you know?

enter image description here

thanks a lot

like image 272
user9969 Avatar asked Sep 08 '11 06:09

user9969

People also ask

How do I enable SQL IntelliSense?

On the Tools menu, click Options. Expand Text Editor, expand Transact-SQL, and then click IntelliSense.

Why IntelliSense is not working in SSMS?

IntelliSense is not available when the Query Editor is connected to earlier versions of the Database Engine. IntelliSense is turned off in the Database Engine Query Editor when the SQLCMD mode is set on.

How do I get IntelliSense to work through SSMS?

How to Enable IntelliSense Feature in SSMS. Open SSMS, click Tools -> Options -> Expand Text Editor -> Expand Transact-SQL and click on IntelliSense as shown in the snippet below. Under Transact-SQL IntelliSense Settings ensure “Enable IntelliSense” checkbox is enabled.

How do I refresh SQL Server IntelliSense?

To refresh the local cache of the Microsoft IntelliSense feature, you can either use the IntelliSense window (Edit > IntelliSense) and click on the Refresh Local Cache option, or just use the keyboard shortcut key CTRL+SHIFT+R.

2 Answers

First of all - intellisense in SQL Server Management Studio 2008 and newer only works against databases that are also 2008 or newer - it will not work against a 2005 database.

Next - have you made sure intellisense is enabled in SSMS ?

enter image description here

Then - if it is enabled - sometimes it helps to refresh the local cache:

enter image description here

like image 86
marc_s Avatar answered Sep 23 '22 13:09

marc_s

Late answer but can be useful to other readers:

If you installed Visual Studio 2010 SP1 and you’re using SQL Server 2008 R2, it is likely that your IntelliSense may stop working. There is a fix for this and it was released in SQL Server 2008 R2 SP1.

For more information please read this KB article: https://support.microsoft.com/en-us/kb/2531482

According this article http://www.sqlshack.com/using-and-troubleshooting-sql-server-intellisense-sql-server-2012-higher/, here are some of the common reasons why IntelliSense isn’t working:

  1. Firstly check if IntelliSense is enabled as explained earlier in the article. Also ensure that the Statement Completions settings are correct.

  2. Ensure that there is no syntax error anywhere on the page before your cursor, resolving the code error should re-activate IntelliSense.

  3. IntelliSense does not work inside comments, uncomment the section to be able to get the suggestions.

  4. IntelliSense does not work inside a quotes. Be sure to place your cursor outside of any quotes.

  5. Ensure that you are connected to a SQL Server Instance or a database project.

  6. IntelliSense is only supported on SQL Server 2008 and higher.

  7. IntelliSense does not work for encrypted objects.

  8. Not all syntax is supported.

  9. Are you running in SQLCMD mode? Unfortunately IntelliSense is not supported in command mode. Return to regular mode to get IntelliSense.

  10. IntelliSense is currently not supported for SQL Azure

like image 24
Jigoro Kano Avatar answered Sep 22 '22 13:09

Jigoro Kano
Sign in to Comment

Related questions

What happens with returning IEnumerable if used with async/await (streaming data from SQL Server with Dapper)?
SQL Group with Order by
Find last sunday
What are the drawbacks of using linked servers in SQL Server?
Refreshing a table in SQL server management studio
How return a count(*) of 0 instead of NULL
Create PK for #temp table failed when the script is run in parallel
WHERE clause with nested multiple conditions
Generate new GUID in SQL Server if one is not provided
How to order by an arbitrary condition in SQL
Sql Order By ... using `Case When` for different Ascending, Descending, and Custom Orders
SQL server Varchar(max) and space taken
What security benefits are provided by using stored procedures to access data?
Is it a good idea to use rowguid as unique key in database design?
SQL Server: Migrate Stored Procedures between Databases, Instances
SQL CASE and local variables
How do I apply subtypes into an SQL Server database?
T-SQL Query for Replication Articles
Can you use an asterisk (*) to filter a column in a WHERE clause under SQL Server 2008?
check if all table rows are equal

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!