sys.sysservers (Transact-SQL)sys.sysservers (Transact-SQL)

適用於: 是SQL Server 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

針對 SQL ServerSQL Server 執行個體能夠將它當做 OLE DB 資料來源進行存取的每部伺服器,各包含一個資料列。Contains one row for each server that an instance of SQL ServerSQL Server can access as an OLE DB data source.

重要

此 SQL Server 2000 系統資料表包含回溯相容性的概觀。This SQL Server 2000 system table is included as a view for backward compatibility. 建議您改用最新版的 SQL Server 系統檢視。We recommend that you use the current SQL Server system views instead. 若要尋找相等的系統檢視或檢視,請參閱將系統資料表對應至系統檢視 (Transact-SQL)To find the equivalent system view or views, see Mapping System Tables to System Views (Transact-SQL). 未來的 Microsoft SQL Server 版本將移除這項功能。This feature will be removed in a future version of Microsoft SQL Server. 請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

資料行名稱Column name 資料類型Data type 描述Description
srvidsrvid smallintsmallint 遠端伺服器的識別碼 (只適用於本機環境)。ID (for local use only) of the remote server.
srvstatussrvstatus smallintsmallint 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
srvnamesrvname sysnamesysname 伺服器的名稱。Name of the server.
srvproductsrvproduct sysnamesysname 遠端伺服器的產品名稱。Product name for the remote server.
providernameprovidername nvarchar(128)nvarchar(128) 存取這部伺服器的 OLE DB 提供者名稱。OLE DB provider name for access to this server.
datasourcedatasource nvarchar(4000)nvarchar(4000) OLE DB 資料來源值。OLE DB data source value.
locationlocation nvarchar(4000)nvarchar(4000) OLE DB 位置值。OLE DB location value.
providerstringproviderstring nvarchar(4000)nvarchar(4000) OLE DB 提供者字串值。OLE DB provider string value.
schemadateschemadate datetimedatetime 上次更新這個資料列的日期。Date this row was last updated.
topologyxtopologyx intint 未使用。Not used.
topologyytopologyy intint 未使用。Not used.
catalogcatalog sysnamesysname 當建立通往 OLE DB 提供者的連接時所用的目錄。Catalog that is used when a connection is made to an OLE DB provider.
srvcollationsrvcollation sysnamesysname 伺服器的定序。The collation of the server.
connecttimeoutconnecttimeout intint 伺服器連接的逾時值設定。Time-out setting for the server-connection.
querytimeoutquerytimeout intint 針對伺服器進行查詢的逾時值設定。Time-out setting for queries against the server.
srvnetnamesrvnetname char(30)char(30) 僅供參考之用。Identified for informational purposes only. 不支援。Not supported. 我們無法保證未來的相容性。Future compatibility is not guaranteed.
isremoteisremote bitbit 1 = 伺服器是遠端伺服器。1 = Server is a remote server.

0 = 伺服器是連結伺服器。0 = Server is a linked server.
rpcrpc bitbit 1 = sp_serveroption@rpc** 設定為true或是上**。1 = sp_serveroption@rpc** set to true or on.

0 = sp_serveroption@rpc** 設定為false或是關閉0 = **sp_serveroption@rpc** set to false or off.
pubpub bitbit 1 = sp_serveroption@pub** 設定為true或是上**。1 = sp_serveroption@pub** set to true or on.

0 = sp_serveroption@pub** 設定為false或是關閉0 = **sp_serveroption@pub** set to false or off.
subsub bitbit 1 = sp_serveroption@sub** 設定為true或是上**。1 = sp_serveroption@sub** set to true or on.

0 = sp_serveroption@sub** 設定為false或是關閉0 = **sp_serveroption@sub** set to false or off.
distdist bitbit 1 = sp_serveroption@dist** 設定為true或是上**。1 = sp_serveroption@dist** set to true or on.

0 = sp_serveroption@dist** 設定為false或是關閉0 = **sp_serveroption@dist** set to false or off.
dpubdpub bitbit 1 = sp_serveroption@dpub** 設定為true或是上**。1 = sp_serveroption@dpub** set to true or on.

0 = sp_serveroption@dpub** 設定為false或是關閉0 = **sp_serveroption@dpub** set to false or off.
rpcoutrpcout bitbit 1 = sp_serveroption@rpc out設定為true或是1 = sp_serveroption@rpc out set to true or on.

0 = sp_serveroption@rpc out設定為false或是關閉0 = sp_serveroption@rpc out set to false or off.
dataaccessdataaccess bitbit 1 = **sp_serveroption@data存取**設定為**true**或是**上**。1 = sp_serveroption@data access set to true or on.

0 = **sp_serveroption@data存取權**設定為**false**或是**關閉**。0 = sp_serveroption@data access set to false or off.
collationcompatiblecollationcompatible bitbit 1 = **sp_serveroption@collation相容**設定為**true**或是**上**。1 = sp_serveroption@collation compatible set to true or on.

0 = **sp_serveroption@collation相容**設定為**false**或是**關閉**。0 = sp_serveroption@collation compatible set to false or off.
systemsystem bitbit 1 = sp_serveroption@system** 設定為true或是上**。1 = sp_serveroption@system** set to true or on.

0 = sp_serveroption@system** 設定為false或是關閉0 = **sp_serveroption@system** set to false or off.
useremotecollationuseremotecollation bitbit 1 = **sp_serveroption@remote定序**設定為**true**或是**上**。1 = sp_serveroption@remote collation set to true or on.

0 = **sp_serveroption@remote定序**設定為**false**或是**關閉**。0 = sp_serveroption@remote collation set to false or off.
lazyschemavalidationlazyschemavalidation bitbit 1 = **sp_serveroption@lazy結構描述驗證**設定為**true**或是**上**。1 = sp_serveroption@lazy schema validation set to true or on.

0 = **sp_serveroption@lazy結構描述驗證**設定為**false**或是**關閉**。0 = sp_serveroption@lazy schema validation set to false or off.
定序collation sysnamesysname 所設定的伺服器定序 **sp_serveroption@collation名稱**。Server collation as set by sp_serveroption@collation name.
nonsqlsubnonsqlsub bitbit 0 = 伺服器是 SQL ServerSQL Server 的執行個體0 = server is an instance of SQL ServerSQL Server

1 = 伺服器不是 SQL ServerSQL Server 的執行個體1 = server is not an instance of SQL ServerSQL Server

另請參閱See Also

將系統資料表對應至系統檢視表(Transact SQL) Mapping System Tables to System Views (Transact-SQL)
相容性檢視 (Transact-SQL)Compatibility Views (Transact-SQL)