August 19, 2015 at 10:09 am
Ive just installed sql server 2014 enterprise and created a new databse from a script generated from a database in a sql server 2008 database. When I select a table and activate the 'select top 1000 rows' option, I get a query window containing the script and a grid view of the table. However, in the script window all the column names are underlined in a red squiggly line and placing the mouse over one of them gives me a message 'invalid column name ' but the column does exist, whats going on here ? Is this a bug with the 2014 management studio ?
August 19, 2015 at 10:20 am
Looks like you need to refresh the Intellisense Local Cache.
August 19, 2015 at 10:50 am
how do I do that ?
August 19, 2015 at 10:59 am
Control-Shift-R in SSMS for SQL Server 2012. I don't have SQL Server 2014 installed yet.
If that doesn't work, start with the Edit menu when you have an active query tab.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply