怎么查看mssqllocaldb的表_visual-studio – 如何修复MSSQLLocalDB？

如果您刚刚安装了LocalDB但尚未启动实例,则会发生这种情况.我不确定重启是否会为我重新启动它(我想它会有),但以下工作无需：

C:\Users\sweaver>sqllocaldb.exe s MSSQLLocalDB

LocalDB instance "MSSQLLocalDB" started.

这应该是你所需要的 – 但这是我在这个过程中使用的完整的诊断步骤.

这是在安装新版本的LocalDB(2014)之前

C:\Users\sweaver>sqllocaldb.exe i

v11.0

然后

C:\Users\sweaver>sqllocaldb.exe i

MSSQLLocalDB

v11.0

然后我立即得到这个错误

C:\Users\sweaver>sqllocaldb.exe i MSSQLLocalDB

The required LocalDB version "0.0" is not installed.

奇怪！那么版本11 – 没关系

C:\Users\sweaver>sqllocaldb.exe i v11.0

Name: v11.0

Version: 11.0.5343.0

Shared name:

Owner: RR2014\sweaver

Auto-create: Yes

State: Running

Last start time: 3/10/2016 3:00:29 PM

Instance pipe name: np:\\.\pipe\LOCALDB#60C1AC49\tsql\query

这是版本

C:\Users\sweaver>sqllocaldb.exe v

Microsoft SQL Server 2012 (11.0.5343.0)

Microsoft SQL Server 2014 (12.0.2000.8)

我们来试试吧吧

C:\Users\sweaver>sqllocaldb.exe s MSSQLLocalDB

LocalDB instance "MSSQLLocalDB" started.

然后再试一次…

C:\Users\sweaver>sqllocaldb.exe i MSSQLLocalDB

Name: MSSQLLocalDB

Version: 12.0.2000.8

Shared name:

Owner: RR2014\sweaver

Auto-create: Yes

State: Running

Last start time: 3/10/2016 3:10:55 PM

Instance pipe name: np:\\.\pipe\LOCALDB#1D3F49F3\tsql\query

唷！那很简单！