Compartilhar via

  • Artigo

Propriedade do RDL InstanceName

Obtém o nome da instância do SQL Server. 

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

Sintaxe

'Declaração
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property InstanceName As String
    Get
'Uso
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

Valor da propriedade

Tipo: System. . :: . .String
Um valor String que especifica o nome da instância do SQL Server.

Comentários

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.

Exemplos

C#

Console.WriteLine(srv.InstanceName)

PowerShell

Write-Host $srv.InstanceName