SQL Server 2008 R2智能感知不工作

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.

我有SQL Server 2008 R2，我有Visual Studio 2010 SP1。

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

我在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

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?

问题是我有这么多的补丁可供选择，我不知道你知道哪一个?

thanks a lot

非常感谢

7 个解决方案

#1

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.

首先——SQL Server Management Studio 2008和更新版本的intellisense只能对同样是2008或更新的数据库起作用——它不能对一个2005年的数据库起作用。

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

接下来——您是否确保SSMS中启用了intellisense ?

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

然后——如果启用了——有时有助于刷新本地缓存:

#2

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.

如果您安装了Visual Studio 2010 SP1并且正在使用SQL Server 2008 R2，那么您的智能感知可能会停止工作。对此有一个修正，它是在SQL Server 2008 R2 SP1中发布的。

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

要了解更多信息，请阅读这篇知识库文章: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:

根据这篇文章http://www.sqlshack.com/usand -sql-server- IntelliSense -sql-server-2012-higher/，以下是智能感知不起作用的一些常见原因:

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.

   确保在您的光标之前页面上没有语法错误，解决代码错误应该重新激活IntelliSense。

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

   IntelliSense不工作在注释里面，取消注释就能得到建议。

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.

   确保您连接到SQL服务器实例或数据库项目。

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

   只能在SQL Server 2008或更高版本上支持IntelliSense。

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.

   您是否在SQLCMD模式下运行?不幸的是，命令模式不支持智能感知。返回常规模式以获得智能感知。

10. IntelliSense is currently not supported for SQL Azure

    SQL Azure目前不支持IntelliSense

#3

I just had the same issue and realized that is nothing about VS 2010 or whatever app.

我也有同样的问题，我意识到这和VS 2010或者其他的应用没什么关系。

All you have to do to enable IntelliSense on SQL 2008 is:

你所要做的就是在SQL 2008中启用IntelliSense:

1) Run Windows Update and install 2 updates about SQL Server 2008 (SP1 and SP3);

1)运行Windows Update并安装2个SQL Server 2008更新(SP1和SP3);

2) Restart and make sure Intellisense is enable on SQL Server: Tools>Options>Text Editor>Transact-SQL>IntelliSense

2)重新启动并确保在SQL Server上启用Intellisense: Tools>Options>Text Editor>Transact-SQL> Intellisense

3) Refresh Local Cache by pressing Ctrl + Shift + R

3)按Ctrl + Shift + R刷新本地缓存

4) Done.

4)完成。

#4

Also if you have Query | SQLCMD turned On it will stop IntelliSense from working, even though you have it set up in all the places mentioned above and you are on the latest patch.

另外，如果您打开了查询| SQLCMD，它将停止IntelliSense的工作，即使您在上面提到的所有地方都设置了它，并且您正在使用最新的补丁。

#5

Though you're having SQL Server 2008 R2 IDE but if you're connected with SQL Server 2005, intellisense won't work.

虽然您有SQL Server 2008 R2 IDE，但是如果您连接到SQL Server 2005, intellisense将不起作用。

Please check out this link, it might help you to solve your problem.

请查看这个链接，它可能会帮助你解决你的问题。

#6

To answer your question directly, one of the answers on this post, Why is SQL Server 2008 Management Studio Intellisense not working?, suggests that the second from the bottom would be the one you want:

要直接回答您的问题，本文的答案之一是，为什么SQL Server 2008 Management Studio Intellisense不能工作?，表明从下到下的第二个将是你想要的:

SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x64

SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x64

However, that is just the hotfix that this was released in, there are more current cumulative updates. See the list here: http://support.microsoft.com/kb/981356

然而，这只是发布的热修复，有更多的当前累积更新。请参阅这里的列表:http://support.microsoft.com/kb/981356

#7

Please re-install sql or Search on google Download "SQLServer2008R2-KB2507770-x86.exe" and Run 100% Work For sql sever R2 2008

请重新安装sql或搜索谷歌下载“SQLServer2008R2-KB2507770-x86”。并为sql sever R2 2008运行100%的工作