I'm having a hard time understanding MS SQL Express.
I'm an MS Access developer and I currently have many apps that connect to SQL server. But my understanding in setting up my own version is limited.
I've downloaded SQL Express 2017, which seems to be a 64 bit edition. But it seems that now I have several versions of SQL Express. Take a look at the Configuration Console:
As you can see, the only one running is SQLExpress01. But I don't know what version of SQL this is. Is there a way to tell? Also, is that the latest one?
it loads from "C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS0
r.exe" -sSQLEXPRESS01 which looks like MSSQL Version 14. Why isn't it 17?
The other ones are even older version like MSSQL11.
Using SQL Server Migration Assistant I was able to migrate an old mdb over to SQL, but I can't call up the design in the Management Studio. I get this message when I right click on a table and try and get the design:
Why don't I have the ability to update the tables through Management Studio?
Any help or resources to help me understand these issues would be greatly appreciated.