Contains one row for each remote SQL Server on which this SQL Server can call remote stored procedures.
Column | Datatype | Description |
---|---|---|
srvid | smallint | ID number (for local use only) of the remote server |
srvstatus | smallint | Bitmap of options |
srvname | varchar(30) | Name of the server |
srvnetname | varchar(32) | Reserved (currently the same as srvname) |
topologyx | int | Used by the SQL Enterprise Manager server topology diagram |
topologyy | int | Used by the SQL Enterprise Manager server topology diagram |
csysservers clustered, unique on srvid
ncsysservers nonclustered, unique on srvname
sp_addpublisher | sp_dropremotelogin | sp_helpremotelogin |
sp_addremotelogin | sp_dropserver | sp_helpserver |
sp_addserver | sp_dropsubscriber | sp_helpsubscriberinfo |
sp_addsubscriber | sp_dropsubscription | sp_helpsubscription |
sp_addsubscription | sp_enumfullsubscribers | sp_remoteoption |
sp_changesubscriber | sp_helparticle | sp_serveroption |
sp_changesubscription | sp_helpdistributor | sp_subscribe |
sp_changesubstatus | sp_helppublication | sp_unsubscribe |
sp_droppublisher |