This topic has not yet been rated - Rate this topic

Server Constructor (ServerConnection)

SQL Server 2012

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

C++

JScript

public 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

VBNET

'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()

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD