PromptSQL is a new product that adds auto-complete style Intellisense to Microsoft's standard SQL tools: Query Analyzer, Visual Studio.NET 2003/2005 and SQL Server 2005 Management Studio. Free eval and online demos athttp://www.promptsql.com/
Thanks for the link. Luis Martin Moderator SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important Bertrand Russell All postings are provided “AS IS†with no warranties for accuracy.
I like it! I was rather disappointed to learn that microsoft had scrapped intellisense from SQL Server 2005, but now it doesnt matter anymore <img src='/community/emoticons/emotion-1.gif' alt='' /><br /><br />'I reject your reality and substitute my own' - Adam Savage
FYI we've finally released the first version: http://www.promptsql.com/news.htm Added a lot of stuff like tool-tip descriptions of table columns/types.
Thanks for the information.<br />In case you haven't done so already, what about contacting the webmaster for a software review? Should get more attention than a forum thread in the long run. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
If you are looking for Intellisense functionality and a good strong editor you should check out ApexSQL Edit. www.apexsql.com They have a ton of features that makes life much easier. I see Frank has mentioned them in another thread. http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10553 Curtis
PromptSQL 1.2 is in Beta. Lots of new functionality -- my favorite is being able to hit TAB after the '*' in SELECT * FROM Orders and have the '*' replaced by the list of columns in the Orders table. http://www.promptsql.com/
QuerySense is another tool that acts like an Intellisense system for Query Analyzer. It can be used also for DATABASE DOCUMENTATION and sql-scripts management. You can download a free trial fromhttp://www.paradisebird.net/sqlsense/websqlsense.aspx We are working for a version for Sql Server 2005.