SQL Server:如何查找所有 localdb 实例名称 [英] SQL Server: How to find all localdb instance names
问题描述
我的系统中安装了两个版本(2012 年、2014 年)的 SQL Server Express LocalDB.
I have two versions (2012, 2014) of SQL Server Express LocalDB installed in my system.
如何找到所有现有的 LocalDB
实例名称?
How can I find all existing LocalDB
instance names?
我找到了一种使用命令行的方法,如答案部分所述.
I found a way to do that using command line as mentioned in the answers section.
有没有更好更简单的方法来做到这一点?
Is there a better and easy way to do it?
推荐答案
我发现 SqlLocalDB 实用程序需要在命令行上运行.
I found SqlLocalDB utility that needs to be run on command line.
SqlLocalDB 可以在
SqlLocalDB can be found in
C:\Program Files\Microsoft SQL Server\110\Tools\Binn
或
C:\Program Files\Microsoft SQL Server\120\Tools\Binn
要获取所有现有的 LocalDB
实例名称,请使用:
To get all existing LocalDB
instance names, use:
SqlLocalDB.exe i
info|i
Lists all existing LocalDB instances owned by the current user
and all shared LocalDB instances.
要获取有关特定 LocalDB
实例的详细信息:
To get detailed information about a specific LocalDB
instance:
SqlLocalDB.exe i "MSSQLLocalDB"
info|i "instance name"
Prints the information about the specified LocalDB instance.
这篇关于SQL Server:如何查找所有 localdb 实例名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!