• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

MS SSMS

Recently I began using MS SSMS 2008.
I added a new field "AccountManagerID" to a Table. When I add this field in a stored procedure or using it in designer it compiles and works fine. But I always get the underline characters and when hovering the mouse over it it says "Invalid Column Name " I tried surrounding it with brackets but that made no difference.

>select top 100 CustomerCode, CustomerName, AccountManagerID from tblCustomer
0
Jess31
Asked:
Jess31
  • 4
  • 3
  • 2
1 Solution
 
ghayasurrehmanCommented:
don't worry, this is a bug in MS SSMS 2008 intelllisence.
0
 
ghayasurrehmanCommented:
it will be removed when you right click on the database and click refresh
0
 
BrandonGalderisiCommented:
To refresh the Intellisense auto complete, PRESS <CTRL> + <SHIFT> + D.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Jess31Author Commented:
>ghayasurrehman:
I had tried Refresh on the table, on tables, and on database and that changed nothing
0
 
Jess31Author Commented:
BrandonGalderisi:
where would I press control+shift+D ?
0
 
ghayasurrehmanCommented:
yeah, as I already told you that there is a bug in their intellisense, you have live with it
0
 
BrandonGalderisiCommented:
Just have a query window open and attached to the database which you want to refresh intellisense for.

ghay... I don't think it's a bug personally.... I think it's MSs way of not overburdening the server with excessive schema queries when in more instances than not there are no changes.
0
 
ghayasurrehmanCommented:
right click on the database icon in the treeview and click refresh or  click on the tables folder under the database then click refresh or click on the table you have added and then click refresh or try
Ctrl+Space on the word where you are having error
0
 
Jess31Author Commented:
ghayasurrehman:
>yeah, as I already told you that there is a bug in their intellisense, you have live with it

didn't you write in the next msg:
>it will be removed when you right click on the database and click refresh
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now