SQl 2008 using SQL 2005 management studio

  • sqlnaive

    SSCoach

    Points: 17435

    Can we access SQL server 2008 server using SQL server 2005 management studio [without installing any sql 2008 client] ? If yes, what will be the downfalls ?

  • sharath.chalamgari

    SSCertifiable

    Points: 5680

    you can connect only if you install cumulative update to SQL Server 2005 SP2

  • Malcolm Daughtree

    SSCrazy

    Points: 2373

    It will connect and view but you can't manage it. for example modifing a table gives this

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    Unspecified error

    (MS Visual Database Tools)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    CodeOn

    😛

  • matthew.lowe 19651

    Ten Centuries

    Points: 1192

    You can access , but not manage , backward compatabilty .

    Surely if you have SQL 2008 , why not install SQL 2008 management tools?

    Or replace the central server management tools to have SQL 2008 instead of SQL 2005

    Peace

    Matt

  • Ignacio A. Salom Rangel

    SSC-Insane

    Points: 20443

    The best is to have your management tools from the latest edition of SQL Server.

Viewing 5 posts - 1 through 5 (of 5 total)

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