Query Editor with Intellisense

[Guru7777]

Do any of you use a particular product (doesn't have to be free) that has intellisense for Sql scripting in a Sql Server 2000 environment?

I'm not talking just color coding syntax and awareness of system entities, but also the ability to know that when I say MyTable[DOT], I get a list of columns in my table.

It doesn't matter if it is a plugin for query analyzer or its own standalone product, either.

Another requirement is speed. We've used Apex Sql Edit and when it gets a decent sized query on it, it bogs down.

We've also tried Sql Ide Pro and it got the boot because it couldn't handle special characters included in the name/password field.

So, my question to the experts is, "Are any of you using a really great product that you'd like to rave about?"

Thanks in advance.

----------------------------------------

TWljcm8kb2Z0J3MgIzEgRmFuIQ==

 

[yelworcm]

I do not use it myself, but I have seen PromptSQL advertised on other sites.

 

[Guru7777]

I found that one in my search and have it downloaded, but haven't put it through its paces.

Has anyone used it in a large-scale environment?

----------------------------------------

TWljcm8kb2Z0J3MgIzEgRmFuIQ==