sysservers (master database only)

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

Index

csysservers clustered, unique on srvid

ncsysservers nonclustered, unique on srvname

Referenced by Stored Procedures

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