It is very difficult to remember every table/procedure/function name in sql server specially if your database is very big. I was just thinking that why microsoft has not given intellisense in SQL Server. But then I have found one very good third party software SQL Assistant….
… and the good thing is that till date it is FREE. It provides very good intellisense for SQL Server 2000/2005 in Management Studio/Express, Qurey Analyzer, Enterprise Manager. And it is very small download just 1.3 MB for version 1.0. It works not only for SQL Server but also with DB2, Oracle, MySQL. It can be downloaded from following location –
http://www.softtreetech.com/sqlassist/index.htm
Happy SQL Intellisense……