發行項
04/02/2012

ConnectionContext 屬性

取得 SQL Server 執行個體的目前伺服器連接詳細資料。

命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public ReadOnly Property ConnectionContext As ServerConnection
    Get
'用途
Dim instance As Server
Dim value As ServerConnection

value = instance.ConnectionContext

public ServerConnection ConnectionContext { get; }

public:
virtual property ServerConnection^ ConnectionContext {
    ServerConnection^ get () sealed;
}

abstract ConnectionContext : ServerConnection
override ConnectionContext : ServerConnection

final function get ConnectionContext () : ServerConnection

屬性值

型別：Microsoft.SqlServer.Management.Common. . :: . .ServerConnection
ServerConnection 物件，指定 SQL Server 執行個體的目前連接詳細資料。

實作

IAlienRoot. . :: . .ConnectionContext

備註

This property can be used to change connection settings, such as the name of the instance of SQL Server or the authentication type. The ConnectionContext property is represented by the ServerConnection class. When connecting to the local instance of SQL Server by using Windows Authentication, the default values are used. You do not have to set any properties.

範例

Server srv = new Server("(local)");
ServerConnection conContext = new ServerConnection();
conContext = srv.ConnectionContext;
conContext.LoginSecure = false;
conContext.Login = vlogin;
conContext.Password = vpassword;
Server srv2 = new Server(conContext);

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$conContext = $srv.ConnectionContext
$conContext.LoginSecure = $FALSE
$conContext.Login = vlogin
$conContext.Password = vpassword
$srv2 = new-object Microsoft.SqlServer.Management.Smo.Server($conContext)