Post reply

SQl 2008 using SQL 2005 management studio

  • July 18, 2011 at 4:44 am

    #239892

    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 ?

  • July 18, 2011 at 5:29 am

    #1354162

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

  • July 19, 2011 at 12:32 am

    #1354617

    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

    😛

  • July 19, 2011 at 3:50 am

    #1354681

    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

  • July 20, 2011 at 9:26 am

    #1355746

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



    My blog

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

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