Install regular SQL Server Management Studio over SQL Server Mangement Studio Express (SSMSE)

I installed SQL Server 2005 Express edition with the SQL Server Mangement Studio Express (SSMSE) on my work laptop. When I tried to manage the SQL Server 2005 instances on our servers, I couldn't expand/drill down on the DB Maintenance Plan. This prompted me to find out that this may be one of the features that are lacking in the "Express" version of the SSMS. Therefore I'm in the process of finding a way to 'upgrade' my SSMSE to regular SSMS.

I popped the installation disc of "SQL Server 2005 Standard Edition" and there are client tools/components that I can install which I believe SSMS (Management Studio) is part of it. However when I clicked through the wizard I was told that all the components are already installed and the wizard couldn't go any further.

Is there a way for me to install a regular version of SSMS over my existing SSMSE? Do I have to remove SSMSE first?

Please advise,

Thanks.

The easy thing to do is to remove SSMSE first -as you questioned. Then install SSMS.|||Tip: If you have installed SSMS and then no need to install SSMSE as you can manage Express edition with SSMS alone.|||

Maintenance plans require SQL Agent to be installed on the server machine. SQL Agent doesn't come with SQL Server Express so Management Studio doesn't show maintenance plans when connected to a SQL Server Express server. If you connect to Developer, Workgroup, Standard or Enterprise, you'll see the Maintenance plans folder for those server types in regular SSMS.

Hope this helps,
Steve

|||

Install regular SQL Server Management Studio over SQL Server Mangement Studio Express (SSMSE)

I installed SQL Server 2005 Express edition with the SQL Server Mangement Studio Express (SSMSE) on my work laptop. When I tried to manage the SQL Server 2005 instances on our servers, I couldn't expand/drill down on the DB Maintenance Plan. This prompted me to find out that this may be one of the features that are lacking in the "Express" version of the SSMS. Therefore I'm in the process of finding a way to 'upgrade' my SSMSE to regular SSMS.

I popped the installation disc of "SQL Server 2005 Standard Edition" and there are client tools/components that I can install which I believe SSMS (Management Studio) is part of it. However when I clicked through the wizard I was told that all the components are already installed and the wizard couldn't go any further.

Is there a way for me to install a regular version of SSMS over my existing SSMSE? Do I have to remove SSMSE first?

Please advise,

Thanks.

The easy thing to do is to remove SSMSE first -as you questioned. Then install SSMS.|||Tip: If you have installed SSMS and then no need to install SSMSE as you can manage Express edition with SSMS alone.|||

Maintenance plans require SQL Agent to be installed on the server machine. SQL Agent doesn't come with SQL Server Express so Management Studio doesn't show maintenance plans when connected to a SQL Server Express server. If you connect to Developer, Workgroup, Standard or Enterprise, you'll see the Maintenance plans folder for those server types in regular SSMS.

Hope this helps,
Steve

|||

Install regular SQL Server Management Studio over SQL Server Mangement Studio Express (SSMSE

I installed SQL Server 2005 Express edition with the SQL Server Mangement Studio Express (SSMSE) on my work laptop. When I tried to manage the SQL Server 2005 instances on our servers, I couldn't expand/drill down on the DB Maintenance Plan. This prompted me to find out that this may be one of the features that are lacking in the "Express" version of the SSMS. Therefore I'm in the process of finding a way to 'upgrade' my SSMSE to regular SSMS.

I popped the installation disc of "SQL Server 2005 Standard Edition" and there are client tools/components that I can install which I believe SSMS (Management Studio) is part of it. However when I clicked through the wizard I was told that all the components are already installed and the wizard couldn't go any further.

Is there a way for me to install a regular version of SSMS over my existing SSMSE? Do I have to remove SSMSE first?

Please advise,

Thanks.

The easy thing to do is to remove SSMSE first -as you questioned. Then install SSMS.|||Tip: If you have installed SSMS and then no need to install SSMSE as you can manage Express edition with SSMS alone.|||

Maintenance plans require SQL Agent to be installed on the server machine. SQL Agent doesn't come with SQL Server Express so Management Studio doesn't show maintenance plans when connected to a SQL Server Express server. If you connect to Developer, Workgroup, Standard or Enterprise, you'll see the Maintenance plans folder for those server types in regular SSMS.

Hope this helps,
Steve

|||

Installation and Manage MSDE

We have an application running on SQL-Server and now we want to have another
verison for MSDE. But I could not install it successfully. According to
some articles I know that there would have problem to install MSDE on
Chinese Version (Hongkong) Windows XP. Could someone help to tell me any
solution for this issue.
And, can I use the Enterprises manager to manage the MSDE? And how can I
know any MSDE is running on the PC?
Many Thanks!!!!!
hi,
"BBC1009" <bevis168@.yahoo.com.hk> ha scritto nel messaggio
news:%235n7vqu7EHA.3836@.tk2msftngp13.phx.gbl
> We have an application running on SQL-Server and now we want to have
> another verison for MSDE. But I could not install it successfully.
> According to some articles I know that there would have problem to
> install MSDE on Chinese Version (Hongkong) Windows XP. Could someone
> help to tell me any solution for this issue.
try changing your Windows collation before installing MSDE to one of the
"supported" SQL Server Windows collations

> And, can I use the Enterprises manager to manage the MSDE? And how
> can I know any MSDE is running on the PC?
>
you are not allowed to use Enterprise Manager, Query Analyzer and so on, on
MSDE solutions... you have to rely on home built tools or third party
solutions... please have a look at
http://www.microsoft.com/sql/msde/partners/default.asp ,
http://www.aspfaq.com/show.asp?id=2442 for some of them, both free and
commercial... google for further..
in order to know if you are connected to MSDE instances, you can query for
SET NOCOUNT ON
SELECT SERVERPROPERTY( 'Edition' ) AS [Edition]
which returns, for MSDE,
Edition
Desktop Engine
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql