IntelliSense is not working in SQL Server Management Studio

sql-server sql-server-2008-r2 ssms
Ethem Kuloglu picture Ethem Kuloglu · Jul 23, 2015 · Viewed 47.4k times · Source

We use SQL Server Management Studio 2008 R2. IntelliSense works with SA account perfectly. But it is not working with Windows Authentication user. The user has access master db with db_owner role but it's not sysadmin.

How do I fix this issue?

Answer

Roman Marusyk picture Roman Marusyk · Jul 23, 2015

You can try solution from these questions1 or questions2 and questions3.
Or please try these steps as below:

  • Enable IntelliSense:
    • For all query windows, please go to Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense, and select Enable IntelliSense.
    • For each opening query window, please go to Query >> Intellisense Enabled.
  • Enable statement completion: please go to Tools >> Options >> Text Editor >> Transact-SQL >> General, and check on Auto list members and Parameter information boxes.
  • Refresh IntelliSense local cache: please go to >> Edit >> IntelliSense >>Refresh Local Cache or use the CTRL+Shift+R keyboard shortcut to refresh.
  • Wait a minute or two for the Refresh to finish before trying again.

Related questions

Error Invalid prefix or suffix characters in SQL Server Management Studio

When I try to edit table data in SQL Server Management Studio 2008 R2 (right click in table object, Edit Top 200 rows) I receive this error: "Invalid prefix or suffix characters. (MS Visual Database Tools)".

Read More
Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on …

Read More
Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several …

Read More