+ Reply to Thread
Results 1 to 2 of 2

Difference between Sql Server 2005 Management Studio Express and Management Studio Standard Edition?

  1. Difference between Sql Server 2005 Management Studio Express and Management Studio Standard Edition?

    Is there any difference between SQL Server Management Studio Express and the
    management studio that comes with SQL Server 2005 standard edition?
    Specifically, is diagramming missing from both?

    Thanks,

    Keith



  2. Re: Difference between Sql Server 2005 Management Studio Express and Management Studio Standard Edition?

    Both Management Studio and Management Studio Express support database
    diagrams.
    Anything related to SQL Server Agent is not in Management Studio Express,
    including jobs.
    From http://msdn2.microsoft.com/en-us/library/ms365247.aspx
    SSMSE is different from the complete SQL Server Management Studio in the
    following ways:

    a.. SSMSE cannot manage Analysis Services, Integration Services, SQL
    Server 2005 Mobile Edition, Notification Services, or Reporting Services.

    b.. You cannot update the full-text catalog by using SSMSE. You can use
    sqlcmd utility or Windows Scheduler to update the full-text catalog.

    c.. Interactive Resolver, which lets you resolve conflicts manually during
    on-demand synchronization in Microsoft Windows Synchronization Manager, is
    not supported in SSMSE.

    d.. SSMSE does not support scheduling administrative tasks by using SQL
    Server Agent.

    e.. In SSMSE, Object Explorer only supports Database Engine instances. The
    Connect to Server dialog box prevents connecting to other services, such as
    Analysis Services.

    f.. Because SSMSE is a subset of SQL Server Management Studio, all objects
    that would normally be enumerated for a specific Database Engine Object
    Explorer tree are still visible in SSMSE. If it is an object for an
    unsupported item, only the refresh command is available.

    g.. Help for SSMSE is not installed by the product. If you press F1, MSDN
    Online help opens. Pressing F1, you are able to access all F1 help topics,
    but you do not see a table of contents or an index for the SQL Server 2005
    documentation. To add SQL Server 2005 documentation to SSMSE, install SQL
    Server 2005 Books Online from SQL Server 2005 Books Online Download Center.
    After installing, in the Contents pane of the Books Online, you can use the
    SQL Server Express filter to hide the content that does not apply to SQL
    Server Express edition.

    --
    Rick Byham
    MCDBA, MCSE, MCSA
    Documentation Manager,
    Microsoft, SQL Server Books Online
    This posting is provided "as is" with
    no warranties, and confers no rights.

    "keithb" wrote in message
    news:OV5rO1maGHA.1220@TK2MSFTNGP02.phx.gbl...
    > Is there any difference between SQL Server Management Studio Express and
    > the management studio that comes with SQL Server 2005 standard edition?
    > Specifically, is diagramming missing from both?
    >
    > Thanks,
    >
    > Keith
    >




+ Reply to Thread