If you have been working with SQL Server 2008, you probably noticed that a new feature that comes with the product is Intellisence for writing queries.
However if you wish to use it when you are connected on a database that is in SQL 2005, it will not work as expected. Thanks to my colleagues I found out that there is also SQL Assistant sofware which integrates Intellisence in many IDE tools for MS SQL, MS Access, MySQL, Oracle and so on.
If you often write queries in databases I hardly recommend this product!
More about SQL Assistant you can find at:
http://www.softtreetech.com/isql.htm
879a46e0-9d94-4f9b-adf1-074ce6acd348|2|5.0