Share via

  • Article

ServerConnection Constructor (String)

Initializes a new instance of the ServerConnection class with the specified server instance.

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

Syntax

'Declaration
Public Sub New ( _
    serverInstance As String _
)
'Usage
Dim serverInstance As String

Dim instance As New ServerConnection(serverInstance)

public ServerConnection(
    string serverInstance
)

public:
ServerConnection(
    String^ serverInstance
)

new : 
        serverInstance:string -> ServerConnection

public function ServerConnection(
    serverInstance : String
)

Parameters

  • serverInstance
    Type: System.String
    A String value that specifies the name of the instance of the server with which the connection is established.

Examples

VB

'Connect to a remote instance of SQL Server.
Dim srv As Server
'The strServer string variable contains the name of a remote instance of SQL Server.
srv = New Server(strServer)
'The actual connection is made when a property is retrieved. 
Console.WriteLine(srv.Information.Version)
'The connection is automatically disconnected when the Server variable goes out of scope.

PowerShell

#The strServer string variable contains the name of a remote instance of SQL Server
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server($strServer)
#The actual connection is made when a property is retrieved.
Write-Host $srv.Information.Version
$The connection is automatically disconnected when the Server variable goes out of scope.