Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Client Tools

Answered Client Tools

  • Monday, April 30, 2012 5:19 AM
     
     
    Sign In to Vote
    0

     Iam a sql server administrator.i have to handle sql server 2000,2005 and 2008 servers.which tool is best to access any version of sql server for administration.

    Thanks In Advance

     

All Replies

  • Monday, April 30, 2012 5:28 AM
     
     Answered
    Sign In to Vote
    0

    Hello,

    You can use SSMS 2008 (R2, or 2012) to manage all your different versions of SQL Server; only with SQL Server 2000 there are AFAIK some limitations.

    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing

     
  • Monday, April 30, 2012 8:22 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    SQL Server Management Studio 2012: http://technet.microsoft.com/en-us/library/ms174173.aspx.

    Thanks,
    Maggie

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

     
  • Monday, April 30, 2012 11:30 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    SQL Server Management Studio 2012: http://technet.microsoft.com/en-us/library/ms174173.aspx.

    Thanks,
    Maggie

    I would not use SSMS 2012 to manage lower SQL Server version due to some incompatibility in Wizard generates code which don't work on older versions even. (I've to agree the same problem may exitist SSMS 2008 managing SQL Server 2000)

    If you don't use GUI/Wizard to manage the server but only Query Window to run T-SQL scripts it should not be a problem.

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

     
  • Monday, April 30, 2012 10:13 PM
     
     
    Sign In to Vote
    0

    As far as you do not have to manage SQL 2012 you can stay on Sql Server Management Tools 2008 R2 (SSMS 2008R2).

    You can also ADDITIONALLY install SSMS2012 - that is not a problem. Both versions can co-exist. When installing tools do not choose "upgrade", but choose "new instance" and then install tools only.

    SSMSBoost - ssms add-in adds quick source code navigation to SSMS, quick connection management & switching, shortcuts, auto replacements and object search. www.ssmsboost.com

     
  • Friday, May 04, 2012 7:03 PM
     
     
    Sign In to Vote
    0

    hi please check out the link given here, for your problem.

    http://www.sqlservercentral.com/blogs/pearlknows/2010/12/13/upgrading-to-sql-server-2008-a-comprehensive-checklist/