February 17, 2011 at 2:40 pm
This is irritating the living daylights out of me.
Create a database.
Create some tables
Close SSMS
Open SSMS
Create Stored Proc on some tables
Create New Table
Create New Proc for the new table.
SSMS is aware of the new table since you can highlight it and press alt F1 to get the def. It is also in the list of tables.
Yet Every object from that table, including the table is underlined in squigly red lines, and is not available when trying to use the tab function. Also If I hover the cursor over the "error text" It shows a tool tip text that the object is not available.
I have to close and open SSMS in order for it to recognize the new objects :crazy:
Guess this bug is good for Prompt sales, esp with the new vamped up version?
I must admit, I have not tried the new prompt yet. My company is not eager to spend money...
Any one know how to fix this error? Or is only me getting this? Perhaps a config problem on my pc?
February 17, 2011 at 2:45 pm
[control] + [shift] + [r]
This will refresh the intellisense.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 17, 2011 at 2:50 pm
Sean Lange (2/17/2011)
[control] + [shift] + [r]This will refresh the intellisense.
Is this the point where I should facepalm my self and shout Doh! in my best Homer Simpson Impersonation?
DOH!
Since about a year ago when we moved development to 2008, I've been restarting SSMS when working on complex procs.
Thanks a mil!!!:cool:
February 17, 2011 at 2:53 pm
LOL no problem. I too hated that until I figured out how to get it to refresh. It really makes sense that SSMS would not be checking everytime some sql is run to decided if it needs to refresh, or worse yet did it every time. Glad to save you some headaches. :w00t:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 17, 2011 at 3:04 pm
It actually does make sense...
20/20 Hindsight vision 🙂
If you create a custom user control in c#, you need to do a build of the app for the new methods to be available for intelisense.
February 17, 2011 at 3:37 pm
Now the real problem with SSMS Intellisense:
How do you stop it from auto-completing when you press period or space? This has been the single most frustrating aspect of SSMS for me. Pressing escape after every single table/schema/object/column name so it doesn't replace it with the wrong one is AWFUL.
February 17, 2011 at 4:39 pm
Derrick Smith (2/17/2011)
Now the real problem with SSMS Intellisense:How do you stop it from auto-completing when you press period or space?
Turn it off and get a replacement that actually works (unfortunately not free)
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
February 17, 2011 at 5:54 pm
GilaMonster (2/17/2011)
Derrick Smith (2/17/2011)
Now the real problem with SSMS Intellisense:How do you stop it from auto-completing when you press period or space?
Turn it off and get a replacement that actually works (unfortunately not free)
Yep..unfortunately the people in my department who approve such purchases are heavy VS users..and the VS intellisense is actually quite good. They assume SSMS is the same.
April 27, 2011 at 2:20 pm
Intelli-busy body! It is as bad as the legendary (and loathed) paperclip in office.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply