SAP ABAP Table MSSLINKEDSRVSTRUC (Linked server information - output of sp_linkedservers)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSSLINKEDSRVSTRUC	Table Relationship Diagram
Short Description	Linked server information - output of sp_linkedservers

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SRV_NAME	☐	MSSLINKEDSRV	MSSSYSNAME	CHAR	128	0	Linked server name
2	SRV_PROVIDERNAME	☐	MSSLSPRVDNM		CHAR	128	0	Name of the OLE DB provider managing access to linked server
3	SRV_PRODUCT	☐	MSSLSPRODUCT		CHAR	128	0	Product name of the linked server.
4	SRV_DATASOURCE	☐	MSSLSDS		CHAR	4000	0	OLE DB data source property belonging to a linked server
5	SRV_PROVIDERSTRING	☐	MSSLSPROVSTR		CHAR	4000	0	OLE DB provider string property of a linked server
6	SRV_LOCATION	☐	MSSLSLOC		CHAR	4000	0	OLE DB location property of a linked server
7	SRV_CAT	☐	MSSLSCAT	MSSSYSNAME	CHAR	128	0	OLE DB catalog property of a linked server

History

Last changed by/on	SAP	20110908
SAP Release Created in	710