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 _
)
public Server (
    ServerConnection serverConnection
)
public:
Server (
    ServerConnection^ serverConnection
)
public Server (
    ServerConnection serverConnection
)
public function Server (
    serverConnection : ServerConnection
)

Parameters

  • serverConnection

Remarks

Updated text:

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

'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 = "AdventureWorks"
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)

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

Server Class
Server Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

How to: Copy an SMO Object in Visual Basic .NET
Connecting to an Instance of SQL Server
Disconnecting from an Instance of SQL Server
Managing Servers

Change History

Release

History

New content:
  • Added code sample to the Example section.