Hey Guys, For SQL Server 2008, sometimes we might not get auto-complete feature. In scripts, keywords to be in UPPER case. While formatting, it would be difficult. So we have a FREE tool from APEX, it is an add-in for both SSMS and VS-IDE. http://www.apexsql.com/sql_tools_complete_features.aspx For Intelligent SQL auto-complete add-in Code smarter, faster, and easier. Try it, its worth installing the tool. Enjoy guys!!