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?
Re: Difference between Sql Server 2005 Management Studio Express and Management Studio Standard Edition?
Both Management Studio and Management Studio Express support database
Anything related to SQL Server Agent is not in Management Studio Express,
SSMSE is different from the complete SQL Server Management Studio in the
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
e.. In SSMSE, Object Explorer only supports Database Engine instances. The
Connect to Server dialog box prevents connecting to other services, such as
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.
MCDBA, MCSE, MCSA
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"keithb" wrote in message
> 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?