[dba-Tech] SQL express version question

[Fred Hooper]

Yes, it does. If you have multiple SQL Server instances/versions you will have to choose which to connect to; I used 2012 SSMS w/ that and 2005. However, SQL Server Agent doesn't work with Express.

On Jul 29, 2016, at 1:39 PM, John Colby <jwcolby at gmail.com> wrote:

Does SSMS work with Express?  I use SQL Server 2008 for everything but I am working on a game which I hope to use express for.  It would be nice to be able to use SSMS with the express version.  I assume if it does I will beed a later version of SSMS?


> On 7/29/2016 11:38 AM, Fred Hooper wrote:
> HI Michael,
> 
> I faced the same question when I started converting a single, but very
> complex application. I started with 2012, primarily because I already
> had a copy of that development version. After a bit, I did some research
> and found the two points below, which were persuasive for me:
> 
>  1. 2014 brought the ability to better handle complex queries
>  2. 2016 lost the ability to control when and if updates were applied
>     (Express version only)
> 
> I changed the back end to 2014 and could immediately see the speed
> differences with 2014, which I expect to remain with. I'm now about half
> done with the first stage of the conversion.
> 
> Best,
> Fred
>> Zimmer, Michael <mailto:Michael.Zimmer at federalmogul.com>
>> Wednesday, July 27, 2016 12:00 PM
>> Hello All,
>> 
>> Currently at my work, we use literally dozens of MS Access databases
>> that clients utilize across our LAN.
>> Now we are looking at migrating to a SQL Server. So a couple of us
>> here are beginning to dabble in SQL. Due to company policy, we have to
>> only deal with Microsoft products, so I've been looking at the
>> different flavors of SQL Server Express Edition.
>> 
>> My question is what version of SQL Server Express should we be
>> learning on? 2014? Or 2016? What is the difference, if any, between
>> the versions? Any advantages/disadvantages?
>> 
>> Thanks for any advice you can offer!
>> 
>> 
>> Kindest personal regards,
>> 
>> Mike
>> 
>> 
>> _______________________________________________
>> dba-Tech mailing list
>> dba-Tech at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-tech
>> Website: http://www.databaseadvisors.com
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com

-- 
John W. Colby

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com