Where Used List (Function Module) for SAP ABAP Data Element MSSSCHEMA (Schema name)
SAP ABAP Data Element
MSSSCHEMA (Schema name) is used by
# | Object Type | Object Name | Object Description | Package | Structure Package | Software Component |
---|---|---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
||
1 | ![]() |
CCMS_MSS_BACKUP_CHECK
|
Check for the last backup date | ![]() |
![]() |
![]() |
2 | ![]() |
CCMS_MSS_BACKUP_RUNNING
|
check to see if a backup is currently running | ![]() |
![]() |
![]() |
3 | ![]() |
CCMS_MSS_BACKUP_TLOG_CHECK
|
Check for the last transaction log backup time | ![]() |
![]() |
![]() |
4 | ![]() |
CCMS_MSS_ERRORLOG_CHK
|
check error log messages | ![]() |
![]() |
![]() |
5 | ![]() |
CCMS_MSS_HEALTH_SQLSETUP
|
SQL Server parameter setting check | ![]() |
![]() |
![]() |
6 | ![]() |
CCMS_MSS_HEALTH_STARTUP
|
SQL Server parameter setting check | ![]() |
![]() |
![]() |
7 | ![]() |
CCMS_MSS_PERF
|
data cache hit ratio | ![]() |
![]() |
![]() |
8 | ![]() |
CCMS_MSS_SPACE_MGMT
|
present data on the files which make up the SQL Server Database | ![]() |
![]() |
![]() |
9 | ![]() |
EXEC_SQLCMD_MSQ VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
MS SQL Server function to execute sql command | ![]() |
![]() |
![]() |
10 | ![]() |
GET_BACKUP_FILE VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
MS SQL server function to get the list of SAP Job Backup File | ![]() |
![]() |
![]() |
11 | ![]() |
GET_BACKUP_LIST_MSQ VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
MS SQL server function to get the list of SAP backups | ![]() |
![]() |
![]() |
12 | ![]() |
GET_CCMS_JOB_MSQ VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
MS SQL server function to get the list of SAP CCMS planned task | ![]() |
![]() |
![]() |
13 | ![]() |
GET_CCMS_SINGLEJOB_STATUS_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
MS SQL server function to get the list of SAP CCMS planned task | ![]() |
![]() |
![]() |
14 | ![]() |
GET_CONFIGPARAMS_MSQ VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
MS SQL server function to get configuration options | ![]() |
![]() |
![]() |
15 | ![]() |
GET_DBDATA_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
get data on property settings of a SQL Server database | ![]() |
![]() |
![]() |
16 | ![]() |
GET_DWDLLS_MSS VALUE(OBJSCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
retrieve blocking/locking data | ![]() |
![]() |
![]() |
17 | ![]() |
GET_DYNAMICSERVER_MSQ VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
retrieve data about sql server available from the @@variables | ![]() |
![]() |
![]() |
18 | ![]() |
GET_JOB_HIST_MESSAGE VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
MS SQL server function to get the list of SAP Job History Messages | ![]() |
![]() |
![]() |
19 | ![]() |
GET_JOB_HIST_STEPS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
MS SQL server function to get the list of SAP Job History Steps | ![]() |
![]() |
![]() |
20 | ![]() |
GET_LARGEST_TABLES_MSQ
|
MS SQL server function to get the largest tables in database | ![]() |
![]() |
![]() |
21 | ![]() |
GET_LOCKINFO_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
retrieve blocking/locking data | ![]() |
![]() |
![]() |
22 | ![]() |
GET_LOGSIZE_MSQ VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
MS SQL server function to get log file details | ![]() |
![]() |
![]() |
23 | ![]() |
GET_PROCESSINFO_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
get data from sysprocesses | ![]() |
![]() |
![]() |
24 | ![]() |
GET_PROCESSINFO_MSS VALUE(ONE_LOGIN) TYPE MSSSCHEMA DEFAULT 'N'
|
get data from sysprocesses | ![]() |
![]() |
![]() |
25 | ![]() |
GET_SQLERRORLOGS_MSQ VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
retrieve text of SQLServer errorlogs and the sqlagent.out | ![]() |
![]() |
![]() |
26 | ![]() |
GET_SQLFILES_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
get data on the files of a SQL Server database | ![]() |
![]() |
![]() |
27 | ![]() |
GET_SQLPERFACCESS_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
Retrieve data from the counter objects: ACCESS, BUFFER, and SQL Statistics | ![]() |
![]() |
![]() |
28 | ![]() |
GET_SQLPERFCACHE_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
retrieve data from the sap_perfdb from the cache object | ![]() |
![]() |
![]() |
29 | ![]() |
GET_SQLPERFLOCKS_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
retrieve data from the counter objects: LOCKS | ![]() |
![]() |
![]() |
30 | ![]() |
GET_SQLPERFMEMORY_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
retrieve data from sap_perfdb on memory usage | ![]() |
![]() |
![]() |
31 | ![]() |
GET_SQLSETUP_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
retrievesqlsetup messages from rz20 sqlscript | ![]() |
![]() |
![]() |
32 | ![]() |
GET_SQLSETUP_MSS VALUE(SCHEMA2CHECK) TYPE MSSSCHEMA DEFAULT ' '
|
retrievesqlsetup messages from rz20 sqlscript | ![]() |
![]() |
![]() |
33 | ![]() |
GET_STATICSERVER_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
get data on the Server and SQL Server system is on | ![]() |
![]() |
![]() |
34 | ![]() |
GET_TOP_MODIFIED_TABLES_MSQ
|
MS sql server function to get the top modified tables since last startup | ![]() |
![]() |
![]() |
35 | ![]() |
GET_VTLFILESTATS_MSS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
retrieve data from ::fn_virtualfilestats (-1,-1) | ![]() |
![]() |
![]() |
36 | ![]() |
MSQ_DBSTAT_DOWNLOAD
|
SQL Server table statistic download function | ![]() |
![]() |
![]() |
37 | ![]() |
MSS_CHECK_DDL_ALLOWED
|
MSS_CHECK_DDL_ALLOWED | ![]() |
![]() |
![]() |
38 | ![]() |
MSS_CHECK_DDL_ALLOWED REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
MSS_CHECK_DDL_ALLOWED | ![]() |
![]() |
![]() |
39 | ![]() |
MSS_CHECK_JOB_EXISTS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to check job exists in sql server | ![]() |
![]() |
![]() |
40 | ![]() |
MSS_CHECK_SQLAGENT_STARTED VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
Function to check the status of Sql server agent | ![]() |
![]() |
![]() |
41 | ![]() |
MSS_CHECK_VENDOR_BACKUP_TOOL
|
MSS: Function to check for vendor backup tools | ![]() |
![]() |
![]() |
42 | ![]() |
MSS_CHECK_VENDOR_BACKUP_TOOL VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
MSS: Function to check for vendor backup tools | ![]() |
![]() |
![]() |
43 | ![]() |
MSS_COLL_LIST
|
MSSQL DBCOLL : Retrieving performance data | ![]() |
![]() |
![]() |
44 | ![]() |
MSS_COLL_LIST VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
MSSQL DBCOLL : Retrieving performance data | ![]() |
![]() |
![]() |
45 | ![]() |
MSS_COLL_RESET VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
MSSQL DBCOLL : "Reset" performance counters | ![]() |
![]() |
![]() |
46 | ![]() |
MSS_COL_STATS_IN_BROWSER VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Show column statistics in external browser | ![]() |
![]() |
![]() |
47 | ![]() |
MSS_CREATE_CS_INDEX
|
Create Column Store Index | ![]() |
![]() |
![]() |
48 | ![]() |
MSS_DB_AND_SCHEMA
|
Set / check database name and schema name | ![]() |
![]() |
![]() |
49 | ![]() |
MSS_DB_AND_SCHEMA REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA
|
Set / check database name and schema name | ![]() |
![]() |
![]() |
50 | ![]() |
MSS_DELETE_SQLAGENT_JOB VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to create, delete, modify sql agent jobs | ![]() |
![]() |
![]() |
51 | ![]() |
MSS_ENA_DIS_VENDOR_BACKUP_TOOL
|
MSS: Enable/Disable vendor backup tools | ![]() |
![]() |
![]() |
52 | ![]() |
MSS_ENA_DIS_VENDOR_BACKUP_TOOL VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
MSS: Enable/Disable vendor backup tools | ![]() |
![]() |
![]() |
53 | ![]() |
MSS_EXEC_DBCC_CHECKDB VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Execute DBCC CHECKDB for a given database | ![]() |
![]() |
![]() |
54 | ![]() |
MSS_EXEC_DBCC_CHECKTABLE VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Execute DBCC CHECKTABLE for a given table | ![]() |
![]() |
![]() |
55 | ![]() |
MSS_EXEC_DBCC_CHECKTABLE VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Execute DBCC CHECKTABLE for a given table | ![]() |
![]() |
![]() |
56 | ![]() |
MSS_EXEC_DBCC_CHECKTABLE
|
Execute DBCC CHECKTABLE for a given table | ![]() |
![]() |
![]() |
57 | ![]() |
MSS_EXEC_DBCC_SHOWSTATS
|
Execute DBCC SHOW_STATISTICS for a given table and index | ![]() |
![]() |
![]() |
58 | ![]() |
MSS_EXEC_DBCC_SHOWSTATS VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Execute DBCC SHOW_STATISTICS for a given table and index | ![]() |
![]() |
![]() |
59 | ![]() |
MSS_EXEC_DBCC_SHOWSTATS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Execute DBCC SHOW_STATISTICS for a given table and index | ![]() |
![]() |
![]() |
60 | ![]() |
MSS_EXEC_DBCC_UPDATEUSAGE VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Execute DBCC UPDATEUSAGE for a given table (and index) | ![]() |
![]() |
![]() |
61 | ![]() |
MSS_EXEC_DBCC_UPDATEUSAGE VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Execute DBCC UPDATEUSAGE for a given table (and index) | ![]() |
![]() |
![]() |
62 | ![]() |
MSS_EXEC_UPDATESTATS VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Execute UPDATE STATISTICS for a given table (and index) | ![]() |
![]() |
![]() |
63 | ![]() |
MSS_EXEC_UPDATESTATS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Execute UPDATE STATISTICS for a given table (and index) | ![]() |
![]() |
![]() |
64 | ![]() |
MSS_EXISTS_PARTITIONED_TABLE
|
Existenz einer partitionierten Tabelle | ![]() |
![]() |
![]() |
65 | ![]() |
MSS_EXISTS_PARTITION_FUNCTION
|
Check if partition function for a table exists | ![]() |
![]() |
![]() |
66 | ![]() |
MSS_EXISTS_PARTITION_FUNCTION VALUE(SCHEMA_NAME) TYPE MSSSCHEMA DEFAULT ' '
|
Check if partition function for a table exists | ![]() |
![]() |
![]() |
67 | ![]() |
MSS_EXISTS_PARTITION_OF_TABLE VALUE(SCHEMA_NAME) TYPE MSSSCHEMA DEFAULT ' '
|
Existenztest einer Partition fuer partitionierte Tabelle | ![]() |
![]() |
![]() |
68 | ![]() |
MSS_EXISTS_PARTITION_SCHEME VALUE(SCHEMA_NAME) TYPE MSSSCHEMA DEFAULT ' '
|
Check if Partition scheme for a table exists | ![]() |
![]() |
![]() |
69 | ![]() |
MSS_EXISTS_PARTITION_SCHEME
|
Check if Partition scheme for a table exists | ![]() |
![]() |
![]() |
70 | ![]() |
MSS_EXPLAIN_SQL_STMT VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
MS SQL server function to get statistics, showplan for SQL stmt execution. | ![]() |
![]() |
![]() |
71 | ![]() |
MSS_FILLING_PROCESSES VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
MS SQL Server filling additonal information for processes monitor | ![]() |
![]() |
![]() |
72 | ![]() |
MSS_GET_ALL_OBJECTS REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
MSS_GET_ALL_OBJECTS | ![]() |
![]() |
![]() |
73 | ![]() |
MSS_GET_ALL_OBJECTS
|
MSS_GET_ALL_OBJECTS | ![]() |
![]() |
![]() |
74 | ![]() |
MSS_GET_ALL_PART_OBJS VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Determine all partitioned table in the current database (schema) | ![]() |
![]() |
![]() |
75 | ![]() |
MSS_GET_ALL_PART_OBJS
|
Determine all partitioned table in the current database (schema) | ![]() |
![]() |
![]() |
76 | ![]() |
MSS_GET_BACKUP_DETAIL VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to get backup details | ![]() |
![]() |
![]() |
77 | ![]() |
MSS_GET_BACKUP_DEVICES VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to get the list of backup devices. | ![]() |
![]() |
![]() |
78 | ![]() |
MSS_GET_BACKUP_HIST VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to get backup history overview | ![]() |
![]() |
![]() |
79 | ![]() |
MSS_GET_CHECKDBHISTORY_FILES VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
To get CheckdbHistory Files | ![]() |
![]() |
![]() |
80 | ![]() |
MSS_GET_CHECKDBHISTORY_FILES
|
To get CheckdbHistory Files | ![]() |
![]() |
![]() |
81 | ![]() |
MSS_GET_CLUSTERED_INDEX
|
MSS_GET_CLUSTERED_INDEX | ![]() |
![]() |
![]() |
82 | ![]() |
MSS_GET_CLUSTERED_INDEX REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
MSS_GET_CLUSTERED_INDEX | ![]() |
![]() |
![]() |
83 | ![]() |
MSS_GET_COLUMNS_OF_INDEXES REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Bestimme die Spalten der Indexe einer Tabelle | ![]() |
![]() |
![]() |
84 | ![]() |
MSS_GET_COLUMNS_OF_INDEXES
|
Bestimme die Spalten der Indexe einer Tabelle | ![]() |
![]() |
![]() |
85 | ![]() |
MSS_GET_DATABASES VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get all databases in an instance | ![]() |
![]() |
![]() |
86 | ![]() |
MSS_GET_DBSZHIST VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get the table size history for a given table | ![]() |
![]() |
![]() |
87 | ![]() |
MSS_GET_DB_DEV_AND_USR_INFO
|
To get dbs, devices and user info | ![]() |
![]() |
![]() |
88 | ![]() |
MSS_GET_DB_DEV_AND_USR_INFO VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
To get dbs, devices and user info | ![]() |
![]() |
![]() |
89 | ![]() |
MSS_GET_DB_DEV_AND_USR_INFO VALUE(USERNAME) TYPE MSSSCHEMA
|
To get dbs, devices and user info | ![]() |
![]() |
![]() |
90 | ![]() |
MSS_GET_DB_SIZE_DETAILS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get information on the size of all tables and indexes in a database | ![]() |
![]() |
![]() |
91 | ![]() |
MSS_GET_DB_SIZE_INFO VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get information on the size of a database | ![]() |
![]() |
![]() |
92 | ![]() |
MSS_GET_DEP_PART_OBJS
|
Ermittle abhaengige Partitions-Objekte von einer Tabelle | ![]() |
![]() |
![]() |
93 | ![]() |
MSS_GET_FILESZHIST VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get the file size history | ![]() |
![]() |
![]() |
94 | ![]() |
MSS_GET_INDEXES
|
MSS_GET_INDEXES | ![]() |
![]() |
![]() |
95 | ![]() |
MSS_GET_INDEXES REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
MSS_GET_INDEXES | ![]() |
![]() |
![]() |
96 | ![]() |
MSS_GET_INDEX_COLUMNS REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
MSS_GET_INDEX_COLUMNS | ![]() |
![]() |
![]() |
97 | ![]() |
MSS_GET_INDEX_COLUMNS
|
MSS_GET_INDEX_COLUMNS | ![]() |
![]() |
![]() |
98 | ![]() |
MSS_GET_INDEX_STORPARS
|
Bestimme die Speicherparameter eines Indexes | ![]() |
![]() |
![]() |
99 | ![]() |
MSS_GET_INDEX_STORPARS REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Bestimme die Speicherparameter eines Indexes | ![]() |
![]() |
![]() |
100 | ![]() |
MSS_GET_INDEX_TYPE REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Bestimme den Typ eines Indexes | ![]() |
![]() |
![]() |
101 | ![]() |
MSS_GET_INDEX_TYPE
|
Bestimme den Typ eines Indexes | ![]() |
![]() |
![]() |
102 | ![]() |
MSS_GET_JOB_AND_HISTORY_INFO
|
Function to get job and history info | ![]() |
![]() |
![]() |
103 | ![]() |
MSS_GET_JOB_AND_HISTORY_INFO VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to get job and history info | ![]() |
![]() |
![]() |
104 | ![]() |
MSS_GET_JOB_HEADERS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to get job history header information | ![]() |
![]() |
![]() |
105 | ![]() |
MSS_GET_JOB_INFO_AND_LOG VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to get job and history info of a job | ![]() |
![]() |
![]() |
106 | ![]() |
MSS_GET_JOB_INFO_AND_LOG
|
Function to get job and history info of a job | ![]() |
![]() |
![]() |
107 | ![]() |
MSS_GET_LOCKED_TABLES
|
MSS_GET_LOCKED_TABLES | ![]() |
![]() |
![]() |
108 | ![]() |
MSS_GET_LOCKED_TABLES REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
MSS_GET_LOCKED_TABLES | ![]() |
![]() |
![]() |
109 | ![]() |
MSS_GET_OBJECT_TYPE VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Bestimme den Typ eines Objekts | ![]() |
![]() |
![]() |
110 | ![]() |
MSS_GET_OBJECT_TYPE
|
Bestimme den Typ eines Objekts | ![]() |
![]() |
![]() |
111 | ![]() |
MSS_GET_PARTITION_NUMBER
|
Ermittle Nummer einer Partition | ![]() |
![]() |
![]() |
112 | ![]() |
MSS_GET_PKC REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
MSS_GET_PKC | ![]() |
![]() |
![]() |
113 | ![]() |
MSS_GET_PKC
|
MSS_GET_PKC | ![]() |
![]() |
![]() |
114 | ![]() |
MSS_GET_RESTORE_HIST VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to get the restore history | ![]() |
![]() |
![]() |
115 | ![]() |
MSS_GET_SAP_SCHEMAS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get all SAP schemas in a database | ![]() |
![]() |
![]() |
116 | ![]() |
MSS_GET_SCHEMAS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get all SAP schemas in a database | ![]() |
![]() |
![]() |
117 | ![]() |
MSS_GET_SCHEMA_SIZE_INFO VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Get information on the size of all tables and indexes in a schema | ![]() |
![]() |
![]() |
118 | ![]() |
MSS_GET_SCHEMA_SIZE_INFO VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get information on the size of all tables and indexes in a schema | ![]() |
![]() |
![]() |
119 | ![]() |
MSS_GET_SCH_AGENT_JOBS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
To get the ist of schduled jobs in next XX days. | ![]() |
![]() |
![]() |
120 | ![]() |
MSS_GET_SERVERINFO
|
MSS-SQL Server Information | ![]() |
![]() |
![]() |
121 | ![]() |
MSS_GET_SINGLE_TABLE_OF_INDEX
|
MSS_GET_SINGLE_TABLE_OF_INDEX | ![]() |
![]() |
![]() |
122 | ![]() |
MSS_GET_SINGLE_TABLE_OF_INDEX REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
MSS_GET_SINGLE_TABLE_OF_INDEX | ![]() |
![]() |
![]() |
123 | ![]() |
MSS_GET_SPID_ACTIVITY VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
Get name of stored procedure being executed on a spid. | ![]() |
![]() |
![]() |
124 | ![]() |
MSS_GET_SP_CONFIG_VALUE VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to get the value for a configuration option | ![]() |
![]() |
![]() |
125 | ![]() |
MSS_GET_SQLAGENT_PROPERTIES VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to get sqlagent properties | ![]() |
![]() |
![]() |
126 | ![]() |
MSS_GET_SQLEXPLAIN VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
MS SQL Server get explain for a given SQL statement | ![]() |
![]() |
![]() |
127 | ![]() |
MSS_GET_SQLREQUESTS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
retrieve the contents of sys.dm_exe_query_stats | ![]() |
![]() |
![]() |
128 | ![]() |
MSS_GET_SQLTEXT REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Bestimme den SQL Definition Statement Text eines Objekts | ![]() |
![]() |
![]() |
129 | ![]() |
MSS_GET_SQLTEXT
|
Bestimme den SQL Definition Statement Text eines Objekts | ![]() |
![]() |
![]() |
130 | ![]() |
MSS_GET_SQLTEXT_BY_HISTID VALUE(SCHEMA) TYPE MSSSCHEMA OPTIONAL
|
MS SQL server function to get sqltext from sap_workload_history | ![]() |
![]() |
![]() |
131 | ![]() |
MSS_GET_STORPARS_OF_INDEXES
|
Bestimme die Speicherparameter aller Indexe einer Tabelle | ![]() |
![]() |
![]() |
132 | ![]() |
MSS_GET_STORPARS_OF_INDEXES REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Bestimme die Speicherparameter aller Indexe einer Tabelle | ![]() |
![]() |
![]() |
133 | ![]() |
MSS_GET_TABHIST VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get the table size history for a given table | ![]() |
![]() |
![]() |
134 | ![]() |
MSS_GET_TABHIST VALUE(CURR_SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get the table size history for a given table | ![]() |
![]() |
![]() |
135 | ![]() |
MSS_GET_TABHIST_DL_LIST VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get the fastest growing tables in the table history | ![]() |
![]() |
![]() |
136 | ![]() |
MSS_GET_TABHIST_DL_LIST VALUE(CURR_SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get the fastest growing tables in the table history | ![]() |
![]() |
![]() |
137 | ![]() |
MSS_GET_TABHIST_LIST VALUE(CURR_SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get a list of the tables in the table size history | ![]() |
![]() |
![]() |
138 | ![]() |
MSS_GET_TABHIST_LIST VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get a list of the tables in the table size history | ![]() |
![]() |
![]() |
139 | ![]() |
MSS_GET_TABLES_OF_INDEX REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Bestimme alle Tabellen mit einem Index mit dem gegebenen Namen | ![]() |
![]() |
![]() |
140 | ![]() |
MSS_GET_TABLES_OF_INDEX
|
Bestimme alle Tabellen mit einem Index mit dem gegebenen Namen | ![]() |
![]() |
![]() |
141 | ![]() |
MSS_GET_TABLE_COLUMNS
|
Bestimme die Spalten einer Tabelle | ![]() |
![]() |
![]() |
142 | ![]() |
MSS_GET_TABLE_COLUMNS VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Bestimme die Spalten einer Tabelle | ![]() |
![]() |
![]() |
143 | ![]() |
MSS_GET_TABLE_SIZE_INFO VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Get size information on a table | ![]() |
![]() |
![]() |
144 | ![]() |
MSS_GET_TABLE_SIZE_INFO VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get size information on a table | ![]() |
![]() |
![]() |
145 | ![]() |
MSS_GET_TABLE_STORPARS REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
MSS_GET_TABLE_STORPARS | ![]() |
![]() |
![]() |
146 | ![]() |
MSS_GET_TABLE_STORPARS
|
MSS_GET_TABLE_STORPARS | ![]() |
![]() |
![]() |
147 | ![]() |
MSS_GET_TOP_N_TABLES VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get the top n largest/modified tables | ![]() |
![]() |
![]() |
148 | ![]() |
MSS_GET_TOP_N_TABLES VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Get the top n largest/modified tables | ![]() |
![]() |
![]() |
149 | ![]() |
MSS_GET_TRIGGERS
|
Lese alle exist. Trigger aus der Systemtabelle | ![]() |
![]() |
![]() |
150 | ![]() |
MSS_GET_TRIGGERS VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Lese alle exist. Trigger aus der Systemtabelle | ![]() |
![]() |
![]() |
151 | ![]() |
MSS_GET_TYPES_OF_INDEXES
|
Bestimme die Typen der Indexe einer Tabelle | ![]() |
![]() |
![]() |
152 | ![]() |
MSS_GET_TYPES_OF_INDEXES REFERENCE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Bestimme die Typen der Indexe einer Tabelle | ![]() |
![]() |
![]() |
153 | ![]() |
MSS_GET_VERSION VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get MS SQL Server version | ![]() |
![]() |
![]() |
154 | ![]() |
MSS_GET_VIEW_INFO VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Get information on a view | ![]() |
![]() |
![]() |
155 | ![]() |
MSS_GET_VIEW_INFO
|
Get information on a view | ![]() |
![]() |
![]() |
156 | ![]() |
MSS_GET_VIEW_INFO VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get information on a view | ![]() |
![]() |
![]() |
157 | ![]() |
MSS_IDX_STATS_IN_BROWSER VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Execute DBCC SHOW_STATISTICS for a given table and index | ![]() |
![]() |
![]() |
158 | ![]() |
MSS_IS_COMP_ENABLED
|
Prüfe ob Dezimalkomprimierung möglich ist | ![]() |
![]() |
![]() |
159 | ![]() |
MSS_IS_COMP_ENABLED REFERENCE(I_SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Prüfe ob Dezimalkomprimierung möglich ist | ![]() |
![]() |
![]() |
160 | ![]() |
MSS_IS_TABLE_DEC_COMPRESSED
|
Ist die Tabelle dezimalkomprimiert? | ![]() |
![]() |
![]() |
161 | ![]() |
MSS_IS_TABLE_DEC_COMPRESSED REFERENCE(I_SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Ist die Tabelle dezimalkomprimiert? | ![]() |
![]() |
![]() |
162 | ![]() |
MSS_JOB_ADD_BATCH
|
MSS: Function to add sql job from new DB13 | ![]() |
![]() |
![]() |
163 | ![]() |
MSS_JOB_DELETE_BATCH
|
MSS: Function to delete Sql job from DBACOCKPIT(DB13) | ![]() |
![]() |
![]() |
164 | ![]() |
MSS_JOB_GET_DIALOG_PARAMETERS
|
MSS: (DB6 Framework) Parameter Dialog for LOGA | ![]() |
![]() |
![]() |
165 | ![]() |
MSS_JOB_HANDLE_BUTTON
|
MSS: Dialog for special Calendar Buttons(Volumes) | ![]() |
![]() |
![]() |
166 | ![]() |
MSS_JOB_PREVIEW
|
MSS: Function to add sql job from new DB13 | ![]() |
![]() |
![]() |
167 | ![]() |
MSS_JOB_SET_DIALOG_PARAMETERS
|
MSS function to set DB13 framework | ![]() |
![]() |
![]() |
168 | ![]() |
MSS_JOB_STOP_BATCH
|
MSS: Function to delete Sql job from DBACOCKPIT(DB13) | ![]() |
![]() |
![]() |
169 | ![]() |
MSS_MON_OBJECT_TYPE
|
Find the type of an object | ![]() |
![]() |
![]() |
170 | ![]() |
MSS_MON_OBJECT_TYPE VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Find the type of an object | ![]() |
![]() |
![]() |
171 | ![]() |
MSS_MON_OBJECT_TYPE VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Find the type of an object | ![]() |
![]() |
![]() |
172 | ![]() |
MSS_MON_SQLTEXT VALUE(OBJ_SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get SQL Text for an MSS object | ![]() |
![]() |
![]() |
173 | ![]() |
MSS_MON_SQLTEXT VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get SQL Text for an MSS object | ![]() |
![]() |
![]() |
174 | ![]() |
MSS_PARAMSTRING_FROM_SQLTEXT VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
MS SQL server function to get parameter string from sqltext | ![]() |
![]() |
![]() |
175 | ![]() |
MSS_PARTITION_STORAGE_GET
|
Get information about partitioning from db | ![]() |
![]() |
![]() |
176 | ![]() |
MSS_R3_OWNS_CURR_DB REFERENCE(SCH) TYPE MSSSCHEMA OPTIONAL
|
R/3 owns the current db or schema: true/false. | ![]() |
![]() |
![]() |
177 | ![]() |
MSS_R3_OWNS_CURR_DB
|
R/3 owns the current db or schema: true/false. | ![]() |
![]() |
![]() |
178 | ![]() |
MSS_READ_TEXT_FILE VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Read a text file on sql server host | ![]() |
![]() |
![]() |
179 | ![]() |
MSS_SELECT_MSQSNAP VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
MS SQL Server read database table MSQSNAP | ![]() |
![]() |
![]() |
180 | ![]() |
MSS_SQLAGENT_JOBS VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ''
|
Function to create, delete, modify sql agent jobs | ![]() |
![]() |
![]() |
181 | ![]() |
MSS_TABLE_DATA_READ VALUE(SCHEMA_NAME) TYPE MSSSCHEMA OPTIONAL
|
Get size information on a table | ![]() |
![]() |
![]() |
182 | ![]() |
MSS_TABLE_DATA_READ VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
Get size information on a table | ![]() |
![]() |
![]() |
183 | ![]() |
MSS_XML_PLAN VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE
|
MS SQL server function to get statistics, showplan for SQL stmt execution. | ![]() |
![]() |
![]() |
184 | ![]() |
RSDU_GET_TABLE_SIZE_INFO_MSS
|
Kopie von MSS_GET_TABLE_SIZE_INFO ohne Prüfung | ![]() |
![]() |
![]() |
185 | ![]() |
SMSS_TEST_CONNECT
|
MSSQL Multi-connect : Test connection | ![]() |
![]() |
![]() |
186 | ![]() |
UPDATE_JOB_MSQ VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT ' '
|
MS SQL server function to enable/disable the job | ![]() |
![]() |
![]() |