SQL Server Management Studio 2008智能感知 [英] SQL Server Management Studio 2008 Intellisense
问题描述
由于智能感知功能，我刚刚安装了SQL Server Express 2008.起初它起作用了，但是后来停止了工作.在寻找检查选项并随后咨询Google时，我发现如果您连接到SQL Server 2005数据库，就会看起来像 Microsoft禁用了智能感知.
I just installed SQL Server Express 2008 because of intellisense feature. It worked at first but than it stopped working. Looking for the option to check and later consulting Google I have found that it looks like Microsoft disabled intellisense if you connect to SQL Server 2005 databases.
这绝对正确吗?
有什么解决方案(某些注册表开关")吗?
Is this absolutely correct ?
Is there any solution for this (some registry "switch") ?
推荐答案
If you'd like to see the feature added, vote for the request on Connect. Here is feedback from the team regarding why it was dropped:
让我分享产品团队的 有关版本支持的信息 IntelliSense.这是一个真正的 从一开始就设计 IntelliSense项目，它是其中的一部分 业务决策.执行 的IntelliSense需要完整的 引擎解析器的保真度 使用客户端进行重建 托管代码库.支持多种 服务器版本意味着设计和 实现多个版本 解析器和相关的基础设施并行. 这使时间和成本成倍增加 开发，测试和支持.在同一时间 那时，核心模块很重要 产品基础不仅使 IntelliSense功能还有其他 产品包括升级顾问到 分析脚本；从长远来看， 可能是任何需要的功能 句法和语义理解 Transact-SQL语言.
Let me share product team’s information about the version support of IntelliSense. This was a truly by-design from the beginning of IntelliSense project and it was a part of business decision. Implementation of IntelliSense requires a full fidelity of engine parser reconstruction in client side using managed code base. Support of multiple server versions means design and implementation of multiple versions of parsers and related infra in parallel. This multiplies time and cost to develop, test and support. At the same time, the core module is an important product base that enables not only IntelliSense feature but also other products including Upgrade Advisor to analyze scripts; in the long term, it is potentially any feature that needs syntactic and semantic understanding of Transact-SQL language.
在CTP5和CTP6中，IntelliSense具有一个 已知的问题，它不正确 检查服务器版本，以便CTP用户 可以连接任何版本的SQL 具有IntelliSense的服务器.虽然一些 用户没有注意到，IntelliSense 无法正常工作. 影响是IntelliSense具有 引导用户的巨大潜力 脚本不正确的Transact-SQL或 错误否定地表示 脚本有错误 在这些版本中完全有效.
In CTP5 and CTP6, IntelliSense had a known issue that it did not correctly check the server version so CTP users could connect any version of SQL Server with IntelliSense. While some users didn't notice it, IntelliSense was not correctly working as desired. The impact was that IntelliSense had a high potential to guide users to script incorrect Transact-SQL or to false-negatively indicate that a script has errors while it is perfectly valid in those versions.
考虑到第一目标 IntelliSense将增加 创作综合体的生产力 查询或存储过程(或简单地 Transact-SQL脚本)，此问题是 被认为是减少的一个因素 生产力，这是一个巨大的负面影响 新功能带来的影响.
Considering the number one goal of IntelliSense is to increase productivity of authoring complex query or stored procedure (or simply Transact-SQL scripts), this issue was regarded as a factor to decrease productivity which is a huge negative impact from a new feature.
在RC0中，此已知问题已得到纠正 IntelliSense检查服务器 版本，并在其上提供其功能 支持的版本，即SQL Server 2008.
In RC0, this known issue was corrected that IntelliSense checks the server version and provides its feature on supported version which is SQL Server 2008.
作为版本1，IntelliSense是 在Transact-SQL的子集上启用 语言.因为大 实施词法分析器的工作范围， 解析器，活页夹和脚本文档 托管代码中的对象模型 整个语言范围.产品 团队正在专注于 扩大语言支持范围.
As a version one, IntelliSense is enabled on a subset of Transact-SQL language. It is because the large scope of work to implement lexer, parser, binder and script document object model in managed code for entire language scope. The product team is moving forward with a focus on expanding the language support scope.
我希望这些信息能为您提供 最少的背景信息为什么 在SQL上选择了目标版本 仅适用于Server 2008.
I hope this information provides the background information at minimum why the target version was selected on SQL Server 2008 only.
任何使用RTM版本的人都应考虑在此处可用的CU1(累积更新1)版本.解决了很多IntelliSense错误.
Anyone using the RTM build should consider the CU1 (Cumulative Update 1) build available here as quite a few IntelliSense bugs were addressed.
这篇关于SQL Server Management Studio 2008智能感知的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
