March 15, 2011 at 2:30 pm
This is just frustrating me to no end. I have created a table in SQL Server 2008 with no problems. I wrote some simple inserts to load test data. No problem.
But when I try to use the table I keep getting my statements underlined in red and when i mouse over I get the message like 'Invalid column name RMS_ResortId' on every column name or 'Invalid Object name SPIResTest.dbo.ResClosedToArrival' on the 'from' statement. This message is causing me problems in other much more complex SQL scripts.
Yet, when I ask for a simple "Select top 1000 rows' from the left side I get the results. But the column names are also underlined.
Anybody have an idea?
Thanks in advance
Mike
Example:
SELECT TOP 1000 [RMS_UniqueId]
,[RMS_ResortID]
,[RMS_RoomType]
,[RMS_FromDate]
,[RMS_ToDate]
,[RMS_Sunday]
,[RMS_Monday]
,[RMS_Tuesday]
,[RMS_Wendsday]
,[RMS_Thursday]
,[RMS_Friday]
,[RMS_Saturday]
,[RMS_Description]
FROM [SPIResTest].[dbo].[ResClosedToArrival]
RMS_UniqueIdRMS_ResortIDRMS_RoomTypeRMS_FromDateRMS_ToDateRMS_SundayRMS_MondayRMS_TuesdayRMS_WendsdayRMS_ThursdayRMS_FridayRMS_SaturdayRMS_Description
1OC 2BR2011-01-052011-01-191111100Testing this
2OC 3BR2011-01-052011-01-191111100Testing this
3SSY 2BR2011-05-052011-05-291110000Testing this
March 15, 2011 at 2:37 pm
Edit -> Intellisense -> Refresh Local Cache (or Ctrl-Shift-R)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2011 at 7:17 am
Thank you. Did the trick. Knew something like this must exist, just never used it. Thanks again.
Mike
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply