Search code examples
sqlsql-server-2014-express

Cannot manage SQL Server Express 2014 with SQL Server Management Studio 2012

A client has upgraded a database from SQL Server Express 2008 to SQL Server Express 2014.

I have lost the ability to edit data, or open tables in design mode for the 2014 database. I can still write stored procedures to do these tasks.

I was successfully using SQL Server Management Studio 2012 to edit data and make changes to the SQL Server Express 2008 database, and still can to an archived copy.

Can anyone advise if SQL Server Management Studio 2012 can be used to edit data and make changes to an SQL Server Express 2014 database?

Solution

  • The answer is yes.

    However in case you want to work with this new database you have on a sql server express 2014, i suggest installing sql server management studio 2014.