Available when viewing the Instance name
1. Service-SQL Server (Instance name), default instance: (MSSQLServer)
Or you can view the local instance when you connect to enterprise management.
2. Through the notebooks table
HKEY_LOCAL_MACHINE/software/Microsoft SQL Server/installedinstance
3. Use commands
Sqlcmd/osql
Sqlcmd-l
Sqlcmd-lC
Osql-l
Obtain the availability example. The following is an example.
Declare @ Table (InstanceName sysname null)
Insert @ table exec SYS. xp_mongoshell 'sqlcmd-LC'
-- Left (@ servername, charindex ('/', @ servername + '/')-1) Replace the current host name, root verification instance naming rules
Select * From @ table where InstanceName like left (@ servername, charindex ('/', @ servername + '/')-1) + '%'
View the example name
C:/Documents and Settings/Roy/Application Data/Microsoft SQL Server/90/tools/Shell/MRU. dat
Returned bytes