[dba-SQLServer] dba-SQLServer Digest, Vol 76, Issue 14

Doug:  Coincidentally I just upgraded my management studio from 2000 to 2008 yesterday.  I had sqlprompt (from Redgate) installed, and that caused the install to bonk.  There is a patch they've issued to allow the install to proceed although I hacked around it by renaming a registry key temporarily.  Details on that via google.
But more importantly, I found after the upgrade that some ssis packages broke.  Thankfully they were still in dev stage.  I don't remember all the things that went wrong, but some of them were relative paths in script tasks no longer worked (had to change to absolute paths), and some db connections just plain broke.  hth.  d lewis

Message: 3
Date: Fri, 19 Jun 2009 09:33:19 -0400
From: James Barash <james at fcidms.com>
Subject: Re: [dba-SQLServer] Installing SQL Server 2005 developer on a
        machine with SQL Server 2005 express edition
To: Discussion concerning MS SQL Server
        <dba-sqlserver at databaseadvisors.com>
Message-ID:
        <12D2F894654B53498DEF840AE12B7BB3115C0933 at fciexchange.fcidms.com>
Content-Type: text/plain; charset="us-ascii"

Doug:

If you just need the Management Studio, you can install that by itself, without installing an instance of SQL Server 2005. I've done that with Management Studio 2008. As I recall, you start the installation and just select the Client Tools and make sure to deselect everything else. I also have the Developer and Express editions on my desktop and they run together without any problems. You just need to install the second version as a named instance. Although I usually shut down the one I'm not using to save memory.

James Barash

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Thursday, June 18, 2009 2:32 PM
To: 'Discussion concerning MS SQL Server'
Subject: [dba-SQLServer] Installing SQL Server 2005 developer on a machine with SQL Server 2005 express edition

Folks,

I am looking at installing SQL Server 2005 developer edition on my development system? The computer currently has Visual Studio 2008 and SQL Server 2005 express edition on it. As things stand now Visual Studio uses the Express edition for projects and web sites. I don't want to screw up my current projects. I would like to have access to the Full version of Management Studio to work on some remote servers.

What is the consensus of the SQL Server gurus on the best way to do this?

Thanks in advance.

Doug


The contents of this e-mail message and its attachments are covered by the Electronic Communications Privacy Act (18 U.S.C. 2510-2521) and are intended solely for the addressee(s) hereof. If you are not the named recipient, or the employee or agent responsible for delivering the message to the intended recipient, or if this message has been addressed to you in error, you are directed not to read, disclose, reproduce, distribute, disseminate or otherwise use this transmission.  If you have received this communication in error, please notify us immediately by return e-mail or by telephone, 530-893-3520, and delete and/or destroy all copies of the message immediately.