0

Query Analyzer Auto-Complete...Woot!

SQL Server

This is something I've wanted for a very long time, but did not have the room in my budget to purchase a tool for.

A company called Red Gate (http://www.red-gate.com/products/SQL_Prompt/index.htm) has a nice piece of software that provides a whole bunch of features for SQL Server and looks to be very much worth its $195.00 price tag.

Apparently though, they released an older version of their tool for free that is still available here:

http://www.bustercollings.com/...

If you've been dreaming for autocomplete in Query Analyzer, then definitely check this thing out. It is a little annoying that it does have to make a seperate connection to the SQL Server to get the database metadata, but very quick and painless. And it makes it so easy to get all your tables / columns while you type.

Enjoy!

Mike.

tags:
sql server
 
I have mixed feelings about this tool. I had it for awhile and there are some cool things about it, but it got annoying after a while so I uninstalled it.
 
posted 961 days ago
Add Comment Reply to: this comment OR this thread
 
 
I definitely find the seperate connection to the DB annoying, but so far I've just been choosing when I need it.

If I'm going to do something small in a DB I know well, I'm not turning it on, but many of the databases I've been working with lately have a lot of tables and I'm not familiar with them completely yet. That's where its invaluable and has already saved me quite a bit of time. This particularly applies to databases that have different naming conventions than I typically use.

Have you noticed anything else that I may not have run into yet?

Mike.
 
posted 960 days ago
View Replies (1) || Add Comment Reply to: this comment OR this thread
 
.: HIDE REPLIES :.
andy said:
 
Complains about needing MDAC 2.8 or higher when I try installing, which I have then fails to complete instal
 
posted 665 days ago
Add Comment Reply to: this comment OR this thread
 
katerty said:
 
I think I'll first of all check and test this free version out, and then decide whether it is worth spending money on.

P.S. My recent development - http://rapid4me.com rapidshare search engine. What would you say about this site? Is it good enough?
 
posted 65 days ago
Add Comment Reply to: this comment OR this thread
 
lerry said:
 
P.S. My recent development - http://rapid4me.com rapidshare search engine. What would you say about this site? Is it good enough?
 
posted 65 days ago
Add Comment Reply to: this comment OR this thread
 

Search