If you’ve been working with new columns or renaming columns in a table and when you go to the stored procedure, the column names are underlined in red and hovering over them shows an ‘Invalid Column Name’ description, don’t worry, it’s not as bad as it seems.
As it turns out, your older values have been cached for intellisense, so the new values aren’t recognized. All you need to do is (in SQL Server Management Studio, with your cursor inside the stored procedure’s open window) go to the ‘Edit’ menu, and at the bottom, you will see a menu item called ‘Intellisense’. Click that item, and then, choose ‘Refresh Local Cache’. Close that window and open it again. Everything will be fine.
All Things DotNet Discussed – Winforms/ASP.Net/SharePoint/WPF