且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在sql server的组合列表中显示所有数据库?

更新时间:2022-11-24 21:31:52

您的问题确实非常不清楚,因此不确定是否有帮助.但是,将babelfish放入其中,我想您的意思是我如何获取所有sql服务器实例的列表并像sql server登录对话框一样登录到其中?

好吧,别再看了.它全部在这里: GNR8-简单的C#类生成器 [ ^ ].忽略主题:这里有一个对话框和代码可以执行我认为您需要的操作.如果没有,请随时忽略.
Your question is really bvery unclear so not sure if this will help. However, putting my babelfish in I think you mean how do I get a list of all sql server instances and log on to one just like the sql server logon dialog?

Well, look no more; it''s all in here: GNR8 - Simple C# Class Generator[^]. Ignore the subject: there is a dialog and code in there to do what I think you need. If not, then feel free to ignore.


^ ]
在本地网络上查找SQL Server实例 [ ^ ]
列出网络上的SQL Server [
Finding SQL Servers on the Network[^]
Locate SQL Server instances on the local network[^]
List SQL Servers on a Network[^]


你好,

您可以使用主表列出SQL Server中的所有数据库.

Hi,

You can use master table for listout all databases in your SQL server.

select name from master.sys.databases



这就是你想要的吗?

希望对您有帮助,

谢谢
-Amit.



is this what you want ?

hope it will help you,

thanks
-Amit.