Select data from sap tables MSS_A



Display SAP table details
  



MSSBACKHIS - MS SQL Server: Backup history information

MSSDATABASE - Name + access permission

MSSMAPPING - MSSQL : Mapping of RAT Columns to the Target Table

MSSPARTDIST - Partition distribution information for a partitioned table

MSSPARTFUNCSTRUC - Information Structure for SQL Server Partioning Function

MSSPARTINFO - Partition information for a partitioned table

MSSPARTITIONSTRUC - Information Structure for Partitioned Table

MSSPARTLISTSTRUC - List of All Partitions Including Interval Values

MSSPARTSCHEMESTRUC - Information Structure for SQL Server Partition Schema

MSSPARTSUMSTRUC - Information Sructure for Partitioning List

MSSPARTTAB - Table partition name list

MSSRANGES - MS SQL Server ranges for deadlock monitor

MSSRATPARA - MSSQL RAT : Input parameter structure

MSSRATSRC - MSSQL: Source Code Line of Automatically Generated RAT Prog.

MSSRAWDATA - Raw data line

MSSTABASORT - Table to display sort options in MSS_RAT_TABANALYZE

MSSTABCOL - Table column properties

MSSTABCOLS - Native SQL Server column names and types

MSSTABHDER - Table control download: table header

MSSTABIDX - Table/Index name pairs

MSSTABLEPROP - MSS SQL Server table properties

MSSTABLESIZELIST - Simple list of various table size values

MSSTABLIST - Object references in an XML showplan

MSSTABREADINFO - Table size information for DB/MSS_TABLE_DATA_READ

MSSTABSIZEDETAIL - Table size detail (only for sql 2005 and later)

MSSTABSIZEINFO - Table size information

MSSTABSTATS - Structure for table history data from sap_tabstats

MSSTABSTOR - Table Memory Parameters

MSSTABSZDELTA - MS SQL Server Table Size delta information

MSSTABSZDELTAEX - Table size delta with additional fields

MSSTASK - MS SQL Server task description (as from msdb..systasks)

MSSTASKHIS - MS SQL Server task history (parts from msdb..syshistory)

MSS_ACTIVE_REQUEST - Active SQL Server requests with their connections & sessions

MSS_ANYSCHEMA - SAP schema

Return Table index