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

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 Server(
	ServerConnection serverConnection
)

Parameters

serverConnection
Type: 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.
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()

Community Additions

ADD
Show:
© 2015 Microsoft