use the intellisense on SQL Server 2005

  • Hi,

    I've installed on my system SQL Server 2005 and 2008.

    when i connect to the 2008 with his management tools,i can use the intellisense feature.

    but if i connect with the sql server 2008 management tool into sql server 2005 i can't use the intellisense feature.

    Why?

    Do i need to setup something that i can use the intellisense feature on sql server 2005 when the management tools are from 2008?

    THX

  • It doesn't work on 2005. Period. Full Stop.

    It doesn't work terribly well on 2008.

    Get Red Gate SQL Prompt. It works great on both and in Visual Studio (although it's a bit rocky in Visual Studio).

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • THX.

  • Certain features of SSMS 2008 are turned off with prior versions. Intellisense is one of them. They didn't write anything to figure out which functions/features work with each version, so the code is disabled.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply