I have created a stored procedure in SQL Server 2012. The procedure works fine and does execute, but I'm just curious, why is it showing this squiggly line below the procedure name?
Below is the image showing my stored procedure:
Asked
Active
Viewed 96 times
0
marc_s
- 732,580
- 175
- 1,330
- 1,459
Kamran Ahmed
- 11,809
- 23
- 69
- 101
-
how do i supposed to see what is on a picture? Could you post code and error? – Sergio Aug 07 '13 at 10:57
-
1That's intellisense, I wouldn't worry about it. There is probably a refresh interval or something like that before it updates itself. – twoleggedhorse Aug 07 '13 at 10:57
-
what happens when you hit **execute**? – Christian Phillips Aug 07 '13 at 10:58
-
1@KamranAhmed dont worry about it... – zxc Aug 07 '13 at 10:58
-
3CONTROL + SHIFT + R to update the intellisense – twoleggedhorse Aug 07 '13 at 10:59
-
1Hmmm Actually, it was the intellisense problem, I refreshed and the line went away. Thanks twoleggedhorse @bew and every one who responded :) – Kamran Ahmed Aug 07 '13 at 11:05
2 Answers
7
Unfortunately, intellisense in SSMS isn't the greatest. This stored proc must be new and SSMS hasn't "learned" about it yet, even though it clearly exists. If you were to close SSMS and reopen it, you wouldn't have this issue. I have been so frustrated with intellisense in SSMS that I've been tempted to just turn it off.
You can also press Ctrl + Shift + R to refresh the local intellisense cache, and that should take care of it.
Randy Minder
- 47,200
- 49
- 204
- 358
3
Press ctrl+shift+R to refresh local intellisense cache and that line will disappear.
Raj
Raj
- 10,653
- 2
- 45
- 52