Intellisense for SQL Server 2005


I have been asked many times why we haven’t got Intellisense in SQL Server 2005 Query Analyzer – well – at least I now have a partial answer. Check out this little utility http://www.promptsql.com/. Early days for me – but I really like it. Let me know how you get on.


I am working with the 1.2 Beta – a bit slow – but very promising.

Comments (2)

  1. Travis Owens says:

    I hope this gets ported to .Net 2.0 so it might see some of the lower memory usage benefits.

    When logging is enabled (I don’t even know what it’s “logging”) the memory usage can be a bit higher than I found acceptable.

    I recommend you disable logging in the app’s settings.

  2. Eric says:

    We’ve bought a license pack after a 30 minutes trial. We also asked for some improvements* and response was quick.

    * 1 connection per server instead of per db (is now included in the latest beta) and support for corrolated subqueries (he’s working on it)

    It works with SQL2000, SQL2005, SSMS, VSTS, QA and some other editor. MS should pay him;)

    Now, if someone could make SSMS work with TFS source control….