[AccessD] SQL Server Express version

MS SQL 2008  seems to have the worst setup since MS SQL 7.
At least that was my experience.
And there is also MS SQL 2008 R2, which has incompatible to MS SQL 2008
back-up format - that's a PITA.

I'd remove MS SQL 2005 completely.
Then I'd get installed MS SQL 2008 (if MS SQL 2008 R2 is commonly used there
then I'd install it).

Then if needed you can install MS SQL 2005 (Express) instance in its own
folder - that will work OK in parallel to MS SQL 2008 (R2) instance(s).
And you can control MS SQL 2005 instance from within MS SQL 2008 (R2)
Management Studio (Express)

I didn't try to install MS SQL 2008 instance on a PC with MS SQL 2008 R2
installed. Anybody?

Thank you.

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: 26 ??????? 2010 ?. 22:17
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SQL Server Express version

Your experience matches mine:
Always wondering whether or not a new release install UPDATES the old
release and completely removes the old, or ADDS the app as a NEW RELEASE.
Worst attribute of the Windows environment IMHO.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd- 
> bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Saturday, December 25, 2010 11:40 PM
> To: VBA; Access Developers discussion and problem solving
> Subject: [AccessD] SQL Server Express version
>
> I have SQL Server Express 10 on my laptop (dev machine).  That appears 
> to be 2005.  I actually have the service there (not running) but I 
> cannot seem to find it in the "programs and features".  So how do I 
> uninstall it in order to install the 2008 version?  Or if I just do an 
> install will it overwrite the old one?  I suspect not.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com