A better SQL editor.

I think that the SQL Query Analyzer and its successor in SQL2005 suck.
They provide no intellisense whatsoever and it just feels like Notepad
with an Execute button. Anyway, what are the SQL editor alternatives
that people here use? Preferably not more expensive than $400.
Thanks.Well, if you want intellisense perhaps you should check out PromptSQL:
http://www.promptsql.com/
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Frank Rizzo" <none@.none.com> wrote in message
news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
>I think that the SQL Query Analyzer and its successor in SQL2005 suck. They
>provide no intellisense whatsoever and it just feels like Notepad with an
>Execute button. Anyway, what are the SQL editor alternatives that people
>here use? Preferably not more expensive than $400.
> Thanks.|||I use aquadata studio. Very nice, Java, intellisense, support for Oracle,
DB2, SQL Server, etc.
"Adam Machanic" wrote:

> Well, if you want intellisense perhaps you should check out PromptSQL:
> http://www.promptsql.com/
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Frank Rizzo" <none@.none.com> wrote in message
> news:eb9mCf84FHA.2404@.TK2MSFTNGP12.phx.gbl...
>
>|||Hi Adam, have you had any problems with PromptSQL? The demo seems
pretty good so far. I feel somewhat apprehensive about entering the
login info for my database for it to connect, do you know anything
about the company?|||Hello Ben,
Atadore, the creator of PromptSQL is a Swiss registered company -- it
will be on the registrar of companies if you need to confirm the owners
etc. Some background about me:
[url]http://www.simple-talk.com/2005/10/26/database-geek-of-the-week-damian-mehers/[/ur
l]
If you contact us via the contact form on our web site I'll be happy to
provide you with any additional information you may need.
Regards,
Damian (author of PromptSQL)|||Well, it needs to connect somehow to get the information...
The company is just one guy, AFAIK. If you don't trust the product, run it
on a dev server and monitor your network for outgoing traffic. But I
seriously doubt that it's doing anything unauthorized.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Ben" <vanevery@.gmail.com> wrote in message
news:1131477133.786224.217760@.g44g2000cwa.googlegroups.com...
> Hi Adam, have you had any problems with PromptSQL? The demo seems
> pretty good so far. I feel somewhat apprehensive about entering the
> login info for my database for it to connect, do you know anything
> about the company?
>|||Adam's blown my cover -- ok so it is just one person ;-)
FWIW PromptSQL makes no use of the network whatsoever. The only file
it accesses is the options XML file.
Regards,
Damian