在 SQL Server Management Studio 中丢失了 IntelliSense [英] Lost the IntelliSense in SQL Server Management Studio

问题描述

我正在运行 SQL-2008 R2 服务器.

I am running SQL-2008 R2 Server.

通常，当我编写查询时，我会得到一个完整的智能感知，显示我的数据库中的所有对象.

Usually when I write a query, I get a full-versed IntelliSense displaying all the objects in my Database.

但是现在当我执行一项任务时，它没有显示 IntelliSense.相反，当我写对象名称时，它显示该对象无效！但是，运行查询会给出正确的结果.

But now when I was onto a task, it showed no IntelliSense. Instead, when I wrote the object names, it showed that object is invalid! However, running the Query gives correct results.

我关闭了管理工作室并重新启动了它.现在一切正常.

I shut-down the Management studio and restarted it. Now all works fine.

我想知道到底出了什么问题.有什么想法吗?

I wanna know what was actually wrong. Any ideas?

推荐答案

您可能需要刷新它.要么

You probably needed to refresh it. Either

1. 转到编辑 -> IntelliSense -> 刷新本地缓存
2. 使用Ctrl+Shift+R

这篇关于在 SQL Server Management Studio 中丢失了 IntelliSense的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！