Server Constructor (ServerConnection)

Initializes a new instance of the Server class based on the specified connection.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub New ( _
    serverConnection As ServerConnection _
)
'Usage
Dim serverConnection As ServerConnection 

Dim instance As New Server(serverConnection)

public Server(
    ServerConnection serverConnection
)

public:
Server(
    ServerConnection^ serverConnection
)

new : 
        serverConnection:ServerConnection -> Server

public function Server(
    serverConnection : ServerConnection
)

Parameters

• serverConnection
  Type: Microsoft.SqlServer.Management.Common.ServerConnection
  A ServerConnection object value that specifies the connection to the instance of SQL Server.

Examples

Visual Basic

'Connect to the local, default instance of SQL Server.
Dim srv1 As Server
srv1 = New Server()
'Modify the default database and the timeout period for the connection.
srv1.ConnectionContext.DatabaseName = "AdventureWorks2012"
srv1.ConnectionContext.ConnectTimeout = 30
'Make a second connection using a copy of the ConnectionContext property and verify settings.
Dim srv2 As Server
srv2 = New Server(srv1.ConnectionContext.Copy)
Console.WriteLine(srv2.ConnectionContext.ConnectTimeout.ToString)

PowerShell

#Connect to the local, default instance of SQL Server.
$srv1 = new-object Microsoft.SqlServer.Management.Smo.Server
#Modify the default database and the timeout period for the connection.
$srv1.ConnectionContext.DatabaseName = "AdventureWorks2012"
$srv1.ConnectionContext.ConnectTimeout = 30
#Make a second connection using a copy of the ConnectionContext property and verify settings.
$srv2 = new-object Microsoft.SqlServer.Management.Smo.Server($srv1.ConnectionContext.Copy)
Write-Host $srv2.ConnectionContext.ConnectTimeout.ToString()

See Also

Reference

Server Class

Server Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Connecting to an Instance of SQL Server

Disconnecting from an Instance of SQL Server

Managing Servers