We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

MS SSMS

Jess31
Jess31 asked
on
275 Views
Last Modified: 2012-10-14
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
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
it will be removed when you right click on the database and click refresh
To refresh the Intellisense auto complete, PRESS <CTRL> + <SHIFT> + D.

Author

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

Author

Commented:
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

Author

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
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.