Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ugh3012
Yak Posting Veteran
62 Posts |
 Posted - 2013-06-27 : 13:07:08
|
| Why does my temp table and associated fields get red squiggly line? It’s says invalid object, but it runs fine when I run the query. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-27 : 13:24:47
|
quote:
Originally posted by ugh3012
Why does my temp table and associated fields get red squiggly line? It’s says invalid object, but it runs fine when I run the query.
You can try control-shift-R (or Edit->Intellisense->Refresh Local Cache). If that does not fix it, chalk it up to the Intellisense in SSMS being less than perfect |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2013-06-28 : 19:52:01
|
| I've seen this happen when the temp table doesn't exist yet but "less than perfect" is a good description of the issue.=================================================The cure for anything is salt water -- sweat, tears, or the sea. -Isak Dinesen |
|
|
|
|
|
|
temp table gets a red squiggly line