Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Invalid Column Name error Expand / Collapse
Author
Message
Posted Monday, April 18, 2011 8:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 4, 2014 8:06 AM
Points: 18, Visits: 122
When I select the top 1000 rows from one of my tables, I can see the script used in the top half of my screen and the results in the bottom. The problem I'm having is that 3 of the column names in the script are underlined in red with an error message of 'Invalid Column Name'.
The results part of the screen however show the columns and the data stored inside.

Why am I being told the columns are invalid when they are clearly there in the table.

Many thanks

Stuart.
Post #1095039
Posted Monday, April 18, 2011 9:20 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 8:37 AM
Points: 616, Visits: 3,574
maybe the columns have only just been added, so the intellisense can't see it?
i press ctrl+shift+r to refresh.
Post #1095069
Posted Monday, April 18, 2011 9:29 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:44 AM
Points: 40,602, Visits: 37,057
Edit->Intellisense->Refresh Local cache




Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1095079
Posted Monday, April 18, 2011 9:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 4, 2014 8:06 AM
Points: 18, Visits: 122
Thanks for the help. That seems to have worked.
Post #1095092
Posted Friday, June 6, 2014 5:19 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 3:19 PM
Points: 157, Visits: 608
For what it's worth, I've noticed that in scripts where I first drop a table and then create it, I have to include the "GO" command after the initial DROP statement. Just in case anyone Googling this runs into that issue...


"If I had been drinking out of that toilet, I might have been killed." -Ace Ventura
Post #1578549
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse