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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
it will be removed when you right click on the database and click refresh
To refresh the Intellisense auto complete, PRESS <CTRL> + <SHIFT> + D.
ASKER
>ghayasurrehman:
I had tried Refresh on the table, on tables, and on database and that changed nothing
I had tried Refresh on the table, on tables, and on database and that changed nothing
ASKER
BrandonGalderisi:
where would I press control+shift+D ?
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.
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
Ctrl+Space on the word where you are having error
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
>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