Link to home
Start Free TrialLog in
Avatar of Jess31
Jess31

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of ghayasurrehman
ghayasurrehman
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
it will be removed when you right click on the database and click refresh
To refresh the Intellisense auto complete, PRESS <CTRL> + <SHIFT> + D.
Avatar of Jess31
Jess31

ASKER

>ghayasurrehman:
I had tried Refresh on the table, on tables, and on database and that changed nothing
Avatar of Jess31

ASKER

BrandonGalderisi:
where would I press control+shift+D ?
yeah, as I already told you that there is a bug in their intellisense, you have live with it
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.
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
Avatar of Jess31

ASKER

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