Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 red wave underline

Author  Topic 

eugz
Posting Yak Master

210 Posts

Posted - 2012-03-09 : 12:18:37
Hi All.

In SQL Server 2008 if spelling wrong or some other problem the red wave underline become. It is helpful. But I cannot understand, for instance, I modified table by rename field and try to modify stored procedure based on that table. In that case the renamed field will red underline. Just when I close session and then reopen it back the red underline in stored procedure for renamed field is gone. What need to do to get response of SQL server to some modification in database and don't get red wave underline on existing field(s)?

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-09 : 12:27:00
that may be because it was in existing session that you opened code and it was still not aware of change you did. disconnect the connect and reconect again and it show then display fine

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

eugz
Posting Yak Master

210 Posts

Posted - 2012-03-09 : 12:34:37
Hi visakh16. Thanks for replay.

I just found how to solve that problem. Just use this command CTRL+SHIFT+R
and you are all set, the local Intellisense cache will be rebuilt and your new tables/procs/whatever will show up in Intellisense, cool!
Go to Top of Page
   

- Advertisement -