But not the sort of amphetamines that destroy your nervous system and send you to an early grave.
SQL Prompt from red-gate gives you intellisense-style behaviour inside Sql Query Analyser. Amazingly, you can download Sql Prompt for free. Not a time-limited or feature limited version, but the full version. Requires registration -- but if you instruct them not to spam you, they won't.
This is a genuine endorsement by the way, not a sponsored one. ;-)
continues with animation...