It's not SSMS that runs your queries, it's SQL Server. Just run the query, and if it works, just smile. Don't be a slave under this intlellinonsense. (I have it turned off. I just can't stand it.)
My t-sql is red as if the table doesn't exist
Alen Cappelletti
1,047
Reputation points
Hi,
I have a strange behavior on a table. My code is not validated in SSMS when writing. The statement works... I tried closing the work window, reconnecting, nothing always in RED. Does anyone have any ideas?
Thanks Alen
SQL Server | Other
{count} votes
-
Viorel 125.8K Reputation points2023-03-13T17:46:57.6866667+00:00 Does it help if you press <Ctrl+Shift+R> and wait few seconds?
-
Alen Cappelletti 1,047 Reputation points
2023-03-13T22:46:08.53+00:00 YESSSSSS!! Viorel! It fixed! Thanks!
(Ctrl+Shift+R) : ) -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-03-14T02:47:40.1933333+00:00 I understand your feelings very well. Sometimes I get the same problem, and even though the query works fine, it shows a red squiggly line. This bothers me.
Glad to see your issue solved.
Best regards,
Percy Tang
Sign in to comment
1 answer
Sort by: Most helpful
-
Erland Sommarskog 129.6K Reputation points MVP Volunteer Moderator2023-03-13T22:18:42.2566667+00:00 -
Alen Cappelletti 1,047 Reputation points
2023-03-13T22:32:34.3133333+00:00 Hi Erland! You're right but I'm moving to SQL Server a long Sybase procedure... and it's very helpful when all the code rewritten are "green"... but it runs...
it's more a curiosity... on the first 1500 rewritten code line only this passage is red!; )
ALEN
Sign in to comment -