SQL Server Performance

Sql server default instance name

Discussion in 'General Developer Questions' started by bharathsivam, Mar 11, 2008.

  1. bharathsivam New Member

    Can anyone let me know how to identify the default instance name of an Sql server 2000?
  2. MohammedU New Member

    Default instance name will be always server name...
    SELECT CONVERT(char(20), SERVERPROPERTY('servername'))
    SELECT CONVERT(char(20), SERVERPROPERTY('InstanceName')) ---
    Returns NULL if the instance name is the default instance, or invalid input or error.

  3. bharathsivam New Member

    Thanks Mohammed.

Share This Page