SQL 2008 Intellisense Problem with New Column

• Eric M Flamm

  Say Hey Kid

  Points: 661

  More actions

  May 10, 2009 at 4:39 pm

  #200197

  Hi, all,

  I am building a pretty simple database to receive data from an XML export package via SSIS. I added some key fields named XXObjectID via SSMS to each table to serve as primary keys. Now when I run a select statement against each table, Intellisense flags the XXObjectID column as "Invalid Column Name" - but the query runs fine. Is there some naming convention about ending names in ID that Intellisense doesn't like?

  Thanks,

  Eric

  [font="Tahoma"]Eric Flamm, Flamm Consulting[/font]
  

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  May 10, 2009 at 7:56 pm

  #991877

  You may need to refresh the Local Cache for Intellisense. Go the the Edit Menu, Select Intellisense -> Refresh Local Cache and see if this fixes it.