Intellisense无法正常运行SSMS 2014

问题描述:

我知道有关此问题的文章很多,但是我找不到解决问题的方法.

I know there are a lot of posts on this issue, however I am unable to find a resolution to my issues.

运行中: SMS 2014 with CU1-SSMS和客户端工具上的版本10.0.2342.0. Visual Studio 2010 SP1-10.0.40219.1 SP1Rel

Running: SMS 2014 with CU1 - Version 10.0.2342.0 on both SSMS and Client Tools. Visual Studio 2010 SP1 - 10.0.40219.1 SP1Rel

连接到: Server 2008 R2 SP2 CU 5-10.50.4276

Connecting to: Server 2008 R2 SP2 CU 5 - 10.50.4276

已验证: 启用IntelliSense. SQLCMD模式已禁用. 刷新了缓存. 经过验证的IntelliSense设置. 服务器不支持包含的数据库,因此已被排除.

Have Verified: IntelliSense in enabled. SQLCMD Mode is disabled. Have Refreshed Cache. Verified IntelliSense settings. Server does not support contained databases so this was ruled out.

行为:

  • 连接到Master数据库时

Intellisense会自动填充并正常运行.列出了所有表以及服务器上的其他数据库.

Intellisense autopopulates and functions normally. All the tables are listed and the additional databases on the server.

  • 连接到非系统数据库时

参数或表都不会自动填充,并且CTRL-J不会执行任何操作.

Neither parameters or tables autopopulate and CTRL-J does not do anything.

还有其他想法可以尝试吗? SSMS 2008 R2在所有数据库上都能正常工作.

Anyone have any other ideas to try? SSMS 2008 R2 worked fine across all the databases.

您可以尝试通过按CTRL + Shift + R按钮刷新本地缓存,然后等待一段时间.

You could try refreshing the local cache by pressing CTRL + Shift + R buttons and wait for a while.