sysservers

Applies to master database only. sysservers contains one row for each remote SAP ASE server, Backup Server™, or Open Server™ on which this SAP ASE server can execute remote procedure calls.

Columns

The columns for sysservers are:

Name	Datatype	Description
`srvid`	`smallint`	ID number (for local use only) of the remote server.
`srvstatus`	`smallint`	Bitmap of options.
`srvstatus2`	`unsigned int`	Bitmap of options.
`srvstat2`	`unsigned int`	Bitmap of server options.
`srvname`	`varchar(30)`	Server name.
`srvnetname`	`varchar (255)`	Interfaces file name for the server.
`srvclass`	`smallint null`	Server category defined by the class parameter of sp_addserver.
`srvsecmech`	`varchar(30) null`	Security mechanism.
`srvcost`	`smallint null`	Provides the network cost in milliseconds for accessing a server over a network. Used only by the SAP ASE query optimizer for evaluating the cost of a query when accessing a proxy table, the default is set to 1,000 ms.
`srvprincipal`	`varchar(255) null`	Specifies the Kerberos principal name for the server. Default value is NULL.

The bit representations for the srvstatus column are:

Status Control Bits for srvstatus Column
Decimal	Hex	Status
0	0x0	Timeouts are enabled
1	0x1	Timeouts are disabled
2	0x2	Network password encryption is enabled
4	0x4	Remote server is read-only
64	0x40	Use message confidentiality
128	0x80	Use message integrity
256	0x100	Mutual authentication

The bit representations for the srvstatus2 column are:

srvstatus2 Control Bits in the sysservers Table
Decimal	Hex	Status
1	0x01	Supports fully qualified table names
2	0x02	Reserved for future use

The server categories for the srvclass column are:

Server Categories is the sysservers Table
`srvclass`	Server category
0	Local server
1	sql_server class server
3	direct_connect class server
4	DB2 class server
6	sds class server
7	SAP ASE class server
8	Adaptive Server Anywhere class server
9	ASIQ class server

Indexes

Unique clustered index on srvid
Nonclustered index on srvname