2

i have SQL Server 2008 Management Studio's i need to be auto-complete while typing a query? as when i write the letter such Cr .. Make Me suggestion to Choose from All Reserved words AS Create .

user3420275
  • 27
  • 2
  • 12
  • It's called intellisense. Take a look here. http://blog.sqlauthority.com/2009/03/31/sql-server-2008-intellisense-does-not-work-enable-intellisense/ – Nick.Mc Jul 31 '14 at 11:43
  • Also here http://stackoverflow.com/questions/552458/why-is-sql-server-2008-management-studio-intellisense-not-working – Nick.Mc Jul 31 '14 at 11:44
  • yes intellisense .the article in blog i know it and do it . but not make suggestion to Choose from Reserved words-that's i need- as when write cr.. suggest to me Create world – user3420275 Jul 31 '14 at 11:51
  • Why would you want to prevent keywords from showing up in intellisense? The point of intellisense is to make writing code easier. Keywords are a major part of queries...hence the name keyword. – Sean Lange Jul 31 '14 at 14:29

3 Answers3

2

Give Red Gate's SQLPrompt a try. It isn't free but there's a free trial you can install to see if you like it.

occasionalDev
  • 84
  • 5
2

ApexSQL Complete will do intellisense for your objects as well as SQL keywords, statements and identifiers. And it's free.

C-Pound Guru
  • 15,967
  • 6
  • 46
  • 67
0
Tools - 
  Options - 
   Text Editor - 
     Transact SQL - 
       General - 
         Auto List Members - Check - OK
Tools - 
  Options - 
    Text Editor - 
      Transact SQL - 
        IntelliSence - 
           Enable IntelliSense - Check - OK
kgu87
  • 2,050
  • 14
  • 12