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
Microsoft SQL Server
Last Comment
Jess31
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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