Tod1d's Thought Process

I knew there was a reason I am still subscribed to Scott Mitchell's blog. He just wrote about a cool little app called SQL Prompt. It sounded great and is free, so I downloaded it and I like it a lot. From Scott's post:

"Visual Studio has long spoiled us with IntelliSense, but one place where it's
been lacking is when writing T-SQL. When I type in SELECT * FROM ..., why can't
I have an IntelliSense drop-down list of the available tables and views in my
database? Well, I can now with Red Gate Software's SQL Prompt tool. This tool
runs as a little guy down in your system tray that detects when writing a query
in SQL Query Analyzer, Management Studio, Visual Studio, or even other programs
(like UltraEdit)."

Now, if it only worked in NotePad 2. You can learn more about SQL Prompt from its product page.