views:

513

answers:

2

Either the autocomplete in SQL Server Management Studio 2008 is buggy, or I am. Either way, when I try to type this and hit the spacebar:

SELECT TOP

Autocomplete immediately changes it to this (Topics is a table in one of our databases, btw):

SELECT Topics

Is there a way to fix, or at least gracefully work around this?

+1  A: 

I think all you can do is hit ESC when the intellisense pop-up appears which will cancel any change it makes, or just turn Intellisense off completely by going to Text Editor -> Transact-SQL -> Intellisense.

tbreffni
+3  A: 

Unfortunately, no. SSMS Intellisense is a 1.0 product, and is not as feature-rich as many third-party products. You can turn it off OR ignore the suggestion (with the ESC key).

Stuart Ainsworth
Perfect, thank you for confirming this. We just upgraded from SQL Server 2000, so this issue is an extremely minor gripe; I just wanted to know if it was a genuine bug. I'll use ESC as a workaround until Microsoft patches it.
AspNyc

related questions