SQL Promot provides intellisense inside your Query Designer in SQL Server and helps you show the entire database schema including table names and their column names. If you are Visual Studio 2005 Intellisense a lot (who doesn't), you may want to try SQL Prompt ASAP and I am sure you will love it.
I write lot of SPs and SQL queries and this tool has saved me ton of time.
Click here to download a free version
and don't forget to share what you think of it.