在SQL Server 2008r2智能感知不起作用？ [英] In SQL server 2008r2 intellisense not working?

问题描述

我正在使用Sql server 2008r2 for Database。智能感知不起作用。我想做什么？



我尝试过：



我试过，Intellisense Enabled，它不起作用。工具 - >选项 - >文字编辑器 - > Transact Sql - >智能感知。它也无效。

I am using Sql server 2008r2 for Database. Intellisense is not working. What i want to do?

What I have tried:

I tried, Intellisense Enabled, it is not working. Tools -> options -> Text Editor -> Transact Sql -> Intellisense. It is also not working.

推荐答案

检查以下几点 -

- 确保连接到使用SQL Server 2008创建的数据库或更高版本

- 如果您最近升级到Visual Studio SP1，请检查以下链接 -

FIX：智能感知功能安装Visual Studio 2010 SP1后，SSMS 2008 R2可能会停止工作 [ ^ ]

- 尝试刷新本地缓存。为此，点击 Ctrl + Shift + R

或转到编辑 - >智能感知 - >刷新本地缓存

- 如果无效，请尝试升级到最新的SQL Server服务包



希望，它有助于：）

Check following points-
-- Make sure you are connecting to a database created with SQL Server 2008 or later
-- If you have recently upgraded to Visual Studio SP1 then check following link-
FIX: The IntelliSense feature in SSMS 2008 R2 may stop working after you install Visual Studio 2010 SP1[^]
--Try refreshing local cache. To do that hit Ctrl+Shift+R
or go to Edit -> IntelliSense -> Refresh Local Cache
--if nothing works, try upgrading to latest SQL Server service packs

Hope, it helps :)

这篇关于在SQL Server 2008r2智能感知不起作用？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！