Skip to main content

Reset SQL Server Management Studios intellisense after a schema change

Capture

For some reason it's taken me a while to cotton on to doing this. In fact I currently have intellisense in management studio switched off as it's main hobbies seem to be trolling me typing.?

My main annoyance is the sea of red every time you add a table or column and the lack of red if you delete a column.?

Anyway, I worked out over the weekend that you can reset the intellisense with ctrl+shit+r

In case you weren't sure how to toggle the intellisense on and off, see the picture. It's under Tools -> Options -> Text Editor -> Transact-SQL -> Intellisense.

:-)

Comments

Dom Finn said…
ha! It's only on certain keyboards unfortunately. I have such a keyboard. I thought you would have been issued one by now? If you don't know, there's an easy way to get one... shout like chewbacca and just randomly bash your keys for 5 days straight at work. Most IT managers know the sign and they'll issue you a special keyboard. It's got shortcut keys to some old coding favourites like 'goto' on there!!

Popular posts from this blog

Reigniting posterous again perhaps

I'm taking another look at Posterous again. I'm not really sure why as I haven't written a proper blog for a while but this seems an easy way to share between all my other tings...

NESTA - Next Gen.

via nesta.org.uk Following on from an article on the BBC about Raspberry Pi, this next gen report has some interesting findings. The scariest stat which I picked out from the BBC website was "out of the 28,767 teachers who were awarded Qualified Teacher Status... in 2010, only three qualified in computing or computing science as their primary qualification" Having worked as a computer science teacher for a year in a school that was a specialist in Computing I can concur that the uptake in Comp Sci was woeful. 2 Students for A2... The other teachers backgrounds in Computer Science was also fairly woeful (most knowing a bit about Office but still a paltry amount even about that). I couldn't speak for my counterpart that I was covering however. I suspect they were fairly up on things. All in all what kills me is that Computer science is not a secondary level subject. Areas are often covered, a little in IT, a little in DT subjects (if kids choose Systems and Contr

Motorola MC65

We have a new PDA in town now. As a replacement for the army of MC9000 and MC70s that are in the field and are being discontinued, we now are moving up to the Motorola MC65. I have had the new handheld for about a week now and have been impressed so far. It's a great improvement over the MC70. I have no idea how the numbering system of the Symbol / Motorola devices works. I assume there must be several ranges such as the 50s 60s and 70s.? Anyway the?PDA?has windows mobile 6.5.3, a better touch screen and is faster. Much faster. The skin that has been put on the OS has also applied to our software and I think it makes it look much cooler. We had several problems in adjusting our software so it would work with the new MC65. First was the change in resolution. The MC70 has a much lower resolution than the MC65s and as some of our screens were not using the auto scale settings in the form and some of the buttons on our forms were created at run time rather than design time, this posed