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 |