Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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)

public ServerConnection(
	string serverInstance
)

Parameters

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

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.

Community Additions

ADD
Show:
© 2015 Microsoft