Just follow the below steps to enable Intellisense in Sql Server 2008.

Step 1:Just make sure, Intellisense is enabled.

1.png

Step 2:Go to Tools -> options. Then enable the intellisense as shown below.

2.png

Step 3:After enabling intellisense, just start to type your view, table name etc.

3.png

Note: It takes table or views with in the selected database.

Step 4:Options: Just change the casing to upper, but only for built in function.

4.png

Step 5:If the “Underline errors” checked to true in the above image, if your object name is wrong it highlight with read underline.

5.png

Step 6:Reference Link:

http://msdn.microsoft.com/en-us/library/bb964729.aspx