Sql Server 2005 AutoCompletion

Question

Does anyone know whether SQLServer 2005 provide auto completion when typing stuff in??

I ve looked in the options many times but cannot find this option which is suprising as a lot of other sql editors do support this

Answer 1

No it does not. Intellisence is well in Sql server 2008, or you can look at RedGate.

RedGate and

SQL Prompt

Answer 2

No. Intellisense only comes in SQL Server 2008, provided that both the server and the client tools are 2008.

There are 3rd party tools that'll give you what you want, tho, such as SQL Prompt