我如何知道我的数据库所在的 SQL Server Express 版本? [英] How do I know what version of SQL Server Express my database is in?

问题描述

大约一年前，我开始在 Visual Studio 2013 中开发应用程序.数据库是 SQL Server Express 版本.

A year ago or so I started to develop an app in Visual Studio 2013. The database was in the SQL Server Express edition.

我现在才回过头来.我已将 VS 升级到 2015 社区版并想使用数据库.但是我打不开.我收到的错误是:

I'm just getting back to it now. I've upgraded VS to 2015 Community edition and wanted to use the DB. But I can't open it. The error I am receiving is:

连接字符串中的数据源值指定未安装的 SQL Server 实例.要解决此问题，您可以选择安装匹配的 SQL Server 实例或修改连接字符串中的数据源值.

The Data Source value in the connection string specifies an instance of SQL Server that is not installed. To resolve this issue, you can either choose to install the matching instance of SQL Server or modify the Data Source value in the connection string.

我正在尝试找出旧数据库的版本，以便我可以安装正确的版本或更改连接字符串.如何找出数据库所在的 SQL Server Express 版本?

I'm trying to figure out what version the old db is in so I can install the proper version or change the connection string. How do I find out the version of SQL Server Express the database is in?

推荐答案

1) 点击server explorer，找到你的数据库

1) Click on server explorer and found your database

2) 右键单击​​解决方案的数据库

2) right click on the database of your solution

3) 在菜单上点击一个新的查询

3) on the menu click for a new query

4) 关于新的查询类型:select @@version

4) on the new query type: select @@version

5) 读取您的数据库版本

5) read for your db version

这篇关于我如何知道我的数据库所在的 SQL Server Express 版本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！