Server Constructor (String)

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

'Declaration
Public Sub New ( _
    name As String _
)
public Server (
    string name
)
public:
Server (
    String^ name
)
public Server (
    String name
)
public function Server (
    name : String
)

Parameters

  • name
    A String value that specifies the name of the instance of Microsoft SQL Server.

Remarks

Updated text:

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.

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

Example

'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.

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: Connect to a Remote Instance of SQL Server by Using Windows Authentication 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.

  • Added to the description in the Remarks section.