SQL Server 2008 R2智能感知无法正常工作 [英] SQL Server 2008 R2 intellisense doesn't work
问题描述
尽管SQL Server 2008 R2 Management Studio已启用,但它在一个月前停止工作.我读到这个问题可能是由.NET Framework 4.0 SP1引起的,并尝试了一些建议,但没有任何效果:
The SQL Server 2008 R2 Management Studio intellisense stopped working a month ago though it is enabled. I read that this issue may be caused by the .NET framework 4.0 SP1 and tried some of the suggestions but nothing worked:
- 我已经安装了累积更新包:
SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x64
- 我重新注册了
TextMgrP.dll
- I have installed the cumulative update package:
SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x64
- I re-registered the
TextMgrP.dll
还有其他建议可以做什么?
Any other suggestions what can be done?
SSMS版本为:Microsoft SQL Server Management Studio 10.50.1617.0
The SSMS version is: Microsoft SQL Server Management Studio 10.50.1617.0
推荐答案
-
确保已连接到SQL Server 2008 Edition. IntelliSense不适用于早期版本的SQL Server.
Make sure you are connected to SQL Server 2008 Edition. IntelliSense does not work with the previous versions of SQL Server.
应该启用IntelliSense.有两种方法可以验证是否启用了IntelliSense. a)从工具栏b)转到工具->选项->文本编辑器-> Transact-SQL-> IntelliSense
IntelliSense should be enabled. There are two ways to verify whether IntelliSense is enabled or not. a) From Toolbar b) Go to Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense
应使用数据库中的最新更改刷新IntelliSense. a)按CTRL + SHIFT + R b)转到编辑"->智能感知"->刷新本地缓存"
IntelliSense should be refreshed with the latest changes in database. a) Press CTRL+SHIFT+R b) Go to Edit -> IntelliSense -> Refresh Local Cache
转到工具->选项->文本编辑器-> Transact-SQL->常规-> IntelliSense选择自动列表成员并检查参数信息.
Go to Tools -> Options -> Text Editor -> Transact-SQL -> General -> IntelliSense Select Auto List Members and Check Parameter Information.
这篇关于SQL Server 2008 R2智能感知无法正常工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!