Bagikan melalui

Server.InstanceName Property

  • Artikel

Gets the instance name of the instance of SQL Server.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property InstanceName As String 
    Get
'Usage
Dim instance As Server 
Dim value As String 

value = instance.InstanceName

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public string InstanceName { get; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property String^ InstanceName {
    String^ get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member InstanceName : string

function get InstanceName () : String

Property Value

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

Remarks

The InstanceName property specifies the name of the instance of SQL Server. This is usually the computer name but it may be a named instance that was specified during setup. InstanceName will return an empty string for the default instance.

Examples

C#

Console.WriteLine(srv.InstanceName)

PowerShell

Write-Host $srv.InstanceName

See Also

Reference

Server Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Setting Properties

Managing Servers