sql服务器服务管理器 [英] sql server service manager

问题描述

你好
我想要一个像sql服务器服务管理器一样工作的程序.
如何在系统上查找名称服务器?

解决方案

您可以使用以下功能找到服务器实例:

DataTable _dtServers = SqlDataSourceEnumerator.Instance.GetDataSources();

您可以使用以下代码附加数据库:

创建数据库的数据库名称
    开启<   filespec  >  [， ... n]
    FOR {附上[WITH <   service_broker_option  > ]
        | ATTACH_REBUILD_LOG}
[;] 

您可以在此处找到有关它的更多信息:单击

顺带一提，您的问题不清楚.根据我的理解，我为您提供了以下链接.看看吧.

希望此 [ 解决方案

You can find the server instances with this function:

DataTable _dtServers = SqlDataSourceEnumerator.Instance.GetDataSources();

And you can attach a DataBase with this code:

CREATE DATABASE database_name
    ON <filespec> [ ,...n ]
    FOR { ATTACH [ WITH <service_broker_option> ]
        | ATTACH_REBUILD_LOG }
[;]

You can find more information about it here: CLICK

BTW your question is not clear. From my understanding i have given you the link below. Check it out.

Hope This[^] will help you.

How to do find name server on the system?

whenever you will entered the sqlserver then, sqlserver will display the server name.

How to do attach a data base on the server?

Use the statement of CREATE DATABASE fn.

这篇关于sql服务器服务管理器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！