SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
SQL Server Management Objects (SMO) Class Library
Microsoft.SqlServer.Management.Smo Namespace
Server Class
Server Properties
ActiveDirectory Property
AffinityInfo Property
AuditLevel Property
Audits Property
BackupDevices Property
BackupDirectory Property
BrowserServiceAccount Property
BrowserStartMode Property
BuildClrVersion Property
BuildClrVersionString Property
BuildNumber Property
Collation Property
CollationID Property
ComparisonStyle Property
ComputerNamePhysicalNetBIOS Property
Configuration Property
ConnectionContext Property
Credentials Property
CryptographicProviders Property
Databases Property
DefaultFile Property
DefaultLog Property
DefaultTextMode Property
Edition Property
Endpoints Property
EngineEdition Property
ErrorLogPath Property
Events Property
FilestreamLevel Property
FilestreamShareName Property
FullTextService Property
Information Property
InstallDataDirectory Property
InstallSharedDirectory Property
InstanceName Property
IsCaseSensitive Property
IsClustered Property
ISfcDomainLite.DomainInstanceName Property
ISfcDomainLite.DomainName Property
ISfcHasConnection.ConnectionContext Property
ISfcSupportsDesignMode.IsDesignMode Property
IsFullTextInstalled Property
IsSingleUser Property
JobServer Property
Language Property
Languages Property
LinkedServers Property
LoginMode Property
Logins Property
Mail Property
MailProfile Property
MasterDBLogPath Property
MasterDBPath Property
MaxPrecision Property
Name Property
NamedPipesEnabled Property
NetName Property
NumberOfLogFiles Property
OleDbProviderSettings Property
OSVersion Property
PerfMonMode Property
PhysicalMemory Property
PhysicalMemoryUsageInKB Property
Platform Property
Processors Property
ProcessorUsage Property
Product Property
ProductLevel Property
ProxyAccount Property
ResourceGovernor Property
ResourceLastUpdateDateTime Property
ResourceVersion Property
ResourceVersionString Property
Roles Property
RootDirectory Property
ServerAuditSpecifications Property
ServerType Property
ServiceAccount Property
ServiceInstanceId Property
ServiceMasterKey Property
ServiceName Property
ServiceStartMode Property
Settings Property
SqlCharSet Property
SqlCharSetName Property
SqlDomainGroup Property
SqlSortOrder Property
SqlSortOrderName Property
Status Property
SystemDataTypes Property
SystemMessages Property
TapeLoadWaitTime Property
TcpEnabled Property
Triggers Property
UserDefinedMessages Property
UserOptions Property
Version Property
VersionMajor Property
VersionMinor Property
VersionString Property
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

Server.InstanceName Property

Gets the instance name of the instance of SQL Server. 

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
C#
C++
F#
JScript
VB
Copy 
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public string InstanceName { get; }

Property Value

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

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#

Copy 
Console.WriteLine(srv.InstanceName)

PowerShell

Copy 
Write-Host $srv.InstanceName
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.