다음을 통해 공유

  • 아티클

InstanceName 속성

SQL Server 인스턴스의 인스턴스 이름을 가져옵니다. 

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property InstanceName As String
    Get
‘사용 방법
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

속성 값

유형: System. . :: . .String
SQL Server 인스턴스의 인스턴스 이름을 지정하는 String 값입니다.

주의

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.

예

C#

Console.WriteLine(srv.InstanceName)

PowerShell

Write-Host $srv.InstanceName