Intelli Sense is enabled by default but can be disabled by going to Tools ➜ Options ➜ Text Editor ➜ Transact SQL ➜ Intelli Sense.
This method will help you Troubleshoot Intelli Sense in SQL Server Management Studio.
This problem is really proving to be a tricky one (and quite annoying).
n type the first letter of table just created it shows me table name as well.
No, no, if I change the structure of a table in SQLServer 2008, any query that I write will NOT be able to refer to the new/modified column - to be able to use it, I have to close the Sql Server Management Studio process, and restart it.
For the purpose of this tip, we're going to restrict that to not behaving as designed, as opposed to not behaving as desired (for example, if you don't like that pressing the space bar or tab auto-completes for you, that's a different discussion).
I thought it would be useful to list out the common symptoms and how you can try to resolve them.Devin is a BI consultant at Pragmatic Works Consulting.Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services.Intelli Sense can be a very powerful ally for the T-SQL developer.It can significantly reduce keystrokes, prevent you from guessing at object names, make sure you spell them correctly (and use the right case), and can help you understand the interface to several programmable entities such as stored procedures and built-in functions.From issues like just not popping up at all, to not working on remote servers and sometimes picking incorrect entries could make it a bit tedious to use and for those of us who started out on SQL Server before the advent of Intelli Sense it was easier just to revert back to good old fashioned typing from memory.