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)

Public Sub New (
	serverConnection As ServerConnection


Type: Microsoft.SqlServer.Management.Common.ServerConnection

A ServerConnection object value that specifies the connection to the instance of SQL Server.

Visual Basic


#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()
Return to top