This topic has not yet been rated - Rate this topic

Server Constructor (String)

SQL Server 2012

SQL Server 2005

Initializes a new instance of the Server class with the specified name.

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

Syntax

C++

JScript

'Declaration
Public Sub New ( _
	name As String _
)
'Usage
Dim name As String 

Dim instance As New Server(name)

Parameters

name: Type: System.String
A String value that specifies the name of the instance of SQL Server.

Remarks

Use this constructor when the required instance of SQL Server is not the local, default instance. You can use this method when the SQL Server instance is local, but is not the default installation. You can also use this method for remote instances of SQL Server.

Examples

Visual Basic

VBNET

'Connect to a remote instance of SQL Server.
Dim srv As Server
'The strServer string variable contains the name of a remote instance of SQL Server.
srv = New Server(strServer)
'The actual connection is made when a property is retrieved. 
Console.WriteLine(srv.Information.Version)
'The connection is automatically disconnected when the Server variable goes out of scope.

PowerShell

#the strServer string variable contains the name of a remote instance of SQL Server.
$srv = new-object Microsoft.SqlServer.Management.Smo.Server($strServer)
#The actual connection is made when a property is retrieved.
Write-Host $srv.Information.Version

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