Post reply

How can we get the SQL server Intelligence

  • August 2, 2011 at 5:44 am

    #144290

    Hi

    I am using Sql server 2005 and I need to know how can we add the Intelligence like .net in sql server management studio.

    please help me on this.

    Regards,

    Sarath

    Kindest Regards,

    Sarath Vellampalli

  • August 2, 2011 at 6:01 am

    #1362070

    Buy SQLPrompt from Redgate.

    SQL 2008 has intellisense only when working against a SQL 2008 server, but it's very bad a lot of the time.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 2, 2011 at 6:02 am

    #1362071

    Hi,

    If you mean intelli-sense then i'm afraid native support for this in SQL Server 2005 is not available.

    There are a few 3rd party tools that will give you this functionality. SQL Complete and SQL Prompt are the 2 i have used. SQL Prompt is better but the company i work for now won't pay the license fee. SQL Complete comes in 2 flavours, Free and Pro. I use the free one at the moment. It's a bit clunky compared with SQL Prompt but still makes life a lot easier.

    Thanks,

    Simon


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

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

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