InstanceRole Table

InstanceRole is a static tbale listing the possible roles of database instances. For some vendors, the role of the database instance affects the costs of licensing.

Table 1. Database columns for InstanceRole table

Database Column



Type: integer. Key. Generated ID

A unique identifier for an InstanceRole. Possible values and the corresponding default names are:

  • 1 = None
  • 2 = Backup
  • 3 = Failover
  • 4 = Mirroring
  • 5 = Standby
  • 6 = Other
  • 7 = Primary.

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing an instance role. Foreign key to the ComplianceResourceString table.


Type: text (max 100 characters)

The text to display if the role resource string has no translation.