Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
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
This topic has not yet been rated - Rate this topic

Server.ServiceInstanceId Property

SQL Server 2008 R2

Gets the ID value that uniquely identifies the service instance for this 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.Standalone)]
public string ServiceInstanceId { get; }

Property Value

Type: System.String
A In32 value that specifies service instance ID value for the instance of SQL Server.

C#

Copy 
Server srv = new Server("(local)");
Console.WriteLine("The service instance ID is: " + srv.ServiceInstanceId);

PowerShell

Copy 
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
Write-Host "The service instance ID is:" $srv.ServiceInstanceId

Reference

Server Class
Microsoft.SqlServer.Management.Smo Namespace
Planning a SQL Server Installation

Other Resources

Managing Servers
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.