intellisense not updating

#1

I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that if I
add a new object (e.g. a new Table) to the database, the intellisense does
not recognize it (i.e. it puts a red underline underneath it) until I exit
SQL Server and restart it. My queries run OK even with the red underline,
but the red underline is annoying as I don't know until I run the script
whether the red underline is pointing to a real error or just hasn't updated
yet. Is there a way to refresh the intellisense without having to restart
SQL Server?
--
Ed

#2

Ed White (ewhite (AT) newsgroups (DOT) nospam) writes:

Quote:

I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that
if I add a new object (e.g. a new Table) to the database, the
intellisense does not recognize it (i.e. it puts a red underline
underneath it) until I exit SQL Server and restart it. My queries run
OK even with the red underline, but the red underline is annoying as I
don't know until I run the script whether the red underline is pointing
to a real error or just hasn't updated yet. Is there a way to refresh
the intellisense without having to restart SQL Server?

As I turn off intellisense the first thing I do when I have installed
SSMS, I cannot help with the question.

But I like to point out taht SSMS != SQL Server. If you stop and start
SSMS, you do not stop and start SQL Server. SQL Server is a server
application that could be running on a different machine. And you
definitely do not have to restart SQL Server itself, to refresh the
metadata for Intellisense. In fact, I would expect it to be sufficient
to open a new query window.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#3

Ed White (ewhite (AT) newsgroups (DOT) nospam) writes:

Quote:

I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that
if I add a new object (e.g. a new Table) to the database, the
intellisense does not recognize it (i.e. it puts a red underline
underneath it) until I exit SQL Server and restart it. My queries run
OK even with the red underline, but the red underline is annoying as I
don't know until I run the script whether the red underline is pointing
to a real error or just hasn't updated yet. Is there a way to refresh
the intellisense without having to restart SQL Server?

As I turn off intellisense the first thing I do when I have installed
SSMS, I cannot help with the question.

But I like to point out taht SSMS != SQL Server. If you stop and start
SSMS, you do not stop and start SQL Server. SQL Server is a server
application that could be running on a different machine. And you
definitely do not have to restart SQL Server itself, to refresh the
metadata for Intellisense. In fact, I would expect it to be sufficient
to open a new query window.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#4

Ed White (ewhite (AT) newsgroups (DOT) nospam) writes:

Quote:

I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that
if I add a new object (e.g. a new Table) to the database, the
intellisense does not recognize it (i.e. it puts a red underline
underneath it) until I exit SQL Server and restart it. My queries run
OK even with the red underline, but the red underline is annoying as I
don't know until I run the script whether the red underline is pointing
to a real error or just hasn't updated yet. Is there a way to refresh
the intellisense without having to restart SQL Server?

As I turn off intellisense the first thing I do when I have installed
SSMS, I cannot help with the question.

But I like to point out taht SSMS != SQL Server. If you stop and start
SSMS, you do not stop and start SQL Server. SQL Server is a server
application that could be running on a different machine. And you
definitely do not have to restart SQL Server itself, to refresh the
metadata for Intellisense. In fact, I would expect it to be sufficient
to open a new query window.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#5

Ed White (ewhite (AT) newsgroups (DOT) nospam) writes:

Quote:

I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that
if I add a new object (e.g. a new Table) to the database, the
intellisense does not recognize it (i.e. it puts a red underline
underneath it) until I exit SQL Server and restart it. My queries run
OK even with the red underline, but the red underline is annoying as I
don't know until I run the script whether the red underline is pointing
to a real error or just hasn't updated yet. Is there a way to refresh
the intellisense without having to restart SQL Server?

As I turn off intellisense the first thing I do when I have installed
SSMS, I cannot help with the question.

But I like to point out taht SSMS != SQL Server. If you stop and start
SSMS, you do not stop and start SQL Server. SQL Server is a server
application that could be running on a different machine. And you
definitely do not have to restart SQL Server itself, to refresh the
metadata for Intellisense. In fact, I would expect it to be sufficient
to open a new query window.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#6

Ed White (ewhite (AT) newsgroups (DOT) nospam) writes:

Quote:

I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that
if I add a new object (e.g. a new Table) to the database, the
intellisense does not recognize it (i.e. it puts a red underline
underneath it) until I exit SQL Server and restart it. My queries run
OK even with the red underline, but the red underline is annoying as I
don't know until I run the script whether the red underline is pointing
to a real error or just hasn't updated yet. Is there a way to refresh
the intellisense without having to restart SQL Server?

As I turn off intellisense the first thing I do when I have installed
SSMS, I cannot help with the question.

But I like to point out taht SSMS != SQL Server. If you stop and start
SSMS, you do not stop and start SQL Server. SQL Server is a server
application that could be running on a different machine. And you
definitely do not have to restart SQL Server itself, to refresh the
metadata for Intellisense. In fact, I would expect it to be sufficient
to open a new query window.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#7

Ed White (ewhite (AT) newsgroups (DOT) nospam) writes:

Quote:

I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that
if I add a new object (e.g. a new Table) to the database, the
intellisense does not recognize it (i.e. it puts a red underline
underneath it) until I exit SQL Server and restart it. My queries run
OK even with the red underline, but the red underline is annoying as I
don't know until I run the script whether the red underline is pointing
to a real error or just hasn't updated yet. Is there a way to refresh
the intellisense without having to restart SQL Server?

As I turn off intellisense the first thing I do when I have installed
SSMS, I cannot help with the question.

But I like to point out taht SSMS != SQL Server. If you stop and start
SSMS, you do not stop and start SQL Server. SQL Server is a server
application that could be running on a different machine. And you
definitely do not have to restart SQL Server itself, to refresh the
metadata for Intellisense. In fact, I would expect it to be sufficient
to open a new query window.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#8

Ed White (ewhite (AT) newsgroups (DOT) nospam) writes:

Quote:

I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that
if I add a new object (e.g. a new Table) to the database, the
intellisense does not recognize it (i.e. it puts a red underline
underneath it) until I exit SQL Server and restart it. My queries run
OK even with the red underline, but the red underline is annoying as I
don't know until I run the script whether the red underline is pointing
to a real error or just hasn't updated yet. Is there a way to refresh
the intellisense without having to restart SQL Server?

As I turn off intellisense the first thing I do when I have installed
SSMS, I cannot help with the question.

But I like to point out taht SSMS != SQL Server. If you stop and start
SSMS, you do not stop and start SQL Server. SQL Server is a server
application that could be running on a different machine. And you
definitely do not have to restart SQL Server itself, to refresh the
metadata for Intellisense. In fact, I would expect it to be sufficient
to open a new query window.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#9

Ed White (ewhite (AT) newsgroups (DOT) nospam) writes:

Quote:

I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that
if I add a new object (e.g. a new Table) to the database, the
intellisense does not recognize it (i.e. it puts a red underline
underneath it) until I exit SQL Server and restart it. My queries run
OK even with the red underline, but the red underline is annoying as I
don't know until I run the script whether the red underline is pointing
to a real error or just hasn't updated yet. Is there a way to refresh
the intellisense without having to restart SQL Server?

As I turn off intellisense the first thing I do when I have installed
SSMS, I cannot help with the question.

But I like to point out taht SSMS != SQL Server. If you stop and start
SSMS, you do not stop and start SQL Server. SQL Server is a server
application that could be running on a different machine. And you
definitely do not have to restart SQL Server itself, to refresh the
metadata for Intellisense. In fact, I would expect it to be sufficient
to open a new query window.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#10

Ed White (ewhite (AT) newsgroups (DOT) nospam) writes:

Quote:

I'm using SQL Server 2008 and I'm writing Queries in SMSS. I find that
if I add a new object (e.g. a new Table) to the database, the
intellisense does not recognize it (i.e. it puts a red underline
underneath it) until I exit SQL Server and restart it. My queries run
OK even with the red underline, but the red underline is annoying as I
don't know until I run the script whether the red underline is pointing
to a real error or just hasn't updated yet. Is there a way to refresh
the intellisense without having to restart SQL Server?

As I turn off intellisense the first thing I do when I have installed
SSMS, I cannot help with the question.

But I like to point out taht SSMS != SQL Server. If you stop and start
SSMS, you do not stop and start SQL Server. SQL Server is a server
application that could be running on a different machine. And you
definitely do not have to restart SQL Server itself, to refresh the
metadata for Intellisense. In fact, I would expect it to be sufficient
to open a new query window.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx