If I understood correctly you would like to enable intellisense in SQL Server, similar to Visual Studio intellisense? If that is correct, I am afraid that I will have to disappoint you, because SQL Server (2000, 2005, 2008 and 2008R2 versions) doesn't provide intellisense like Visual Studio.
I suggest you read this post carefully as it will point you in the right direction:
http://stackoverflow.com/questions/391240/recommendations-for-sql-server-2005-intellisense-tools-add-ins[
^]