Select data from sap tables MSQ

Display SAP table details
  



MSQ10RANGE - MS SQL Server range with CHAR 10

MSQBACKMED - MS SQL SERVER BACKUP MEDIASETS

MSQBACKSET - MS SQL server backup list

MSQBAKFILE - Sqlserver Backup file information

MSQBLOLCKS - MS SQL server blocked locks

MSQBLOPROS - MS SQL server blocked processes

MSQC1RANGE - MS SQL Server range with CHAR 1

MSQC4RANGE - MS SQL Server range with CHAR 4 for DBSTATTMSQ

MSQC5RANGE - MS SQL Server range with CHAR 5

MSQCCMSJOB - MS SQL server list of CCMS planned tasks

MSQCCMSTSK - MS SQL server list of CCMS planned tasks

MSQCOLLIST - MS SQL server - table column and type list

MSQCONFIGU - MS SQL server - structure of sp_configure

MSQCONFPAR - MS SQL server - configuration options

MSQDBASES - MS SQL server databases ( as from sysdatabases )

MSQDBASESZ - MS SQL server Database size details

MSQDBCCRES - MS SQL server dbcc output result set

MSQDBDETAS - MS SQL server database space statistics

MSQDBLIST - MS SQL server list of database names

MSQDBLOGSZ - MS SQL server - log file space status

MSQDBOPTS - MS SQL server database options

MSQDBUSERS - MS SQL server user information etc.,

MSQDEVLIST - MS SQL server Backup device List.

MSQDNSITY - Table density information

MSQERROUT - Structure to hold SQLServer errorlog output

MSQEXPLAIN - MS SQL server - sql statement execution plan options

MSQEXPORT - MS SQL server - structure to hold export parameters

MSQFILELIST - List of files

MSQHISSTEP - Sql Server Job History Steps

MSQIDXDETS - MS SQL server - Index details & statistics

MSQIMPORT - MS SQL server - structure to hold import parameters

MSQJBSHIS - MS SQL server Job History ( from msdb..sysjobhistory (7.0)

MSQJOBHDR - MS SQL server job header information

MSQJOBHIS - MS SQL server job history ( as from msdb..sysjobhistory )

MSQJOBMESS - MS SQL server Job Message (from msdb..sysjobhistory)

MSQJOBSTEP - MS SQL server jobsteps ( as from msdb..sysjobsteps)

MSQLOCKINF - MS sql server lock info information for blockers and waiters

MSQLOGLIST - MS SQL Server database log list

MSQLOGSZ - MS SQL server - log size

MSQOBJECTS - MS SQL server system objects ( as from sysobjects )

MSQPFINFO - MS SQL Server Profiler on: trace info directory

MSQPFLIST - MS SQL Server Profiler list

MSQPFON - MS SQL Server Profiler on: trace info

MSQPFOPS - MS SQL Server profiler operator

MSQPFPLAN - MS SQL Server Profiler: explain plan

MSQPFTRCID - MS SQL Server profiler trace ID list

MSQPROCACH - MS SQL server procedure cache activity

MSQPROCESS - MS SQL server processes ( as from sysprocesses )

MSQPROCINF - MS SQL server - processes informations

MSQRANGE14 - MS SQL Server range with CHAR 14

MSQREFHLP - MS SQL Server Reference help fields

MSQSAPLCKS - MS SQL server sap locks (as from sap_locks)

MSQSAPSULK - MS SQL server - list of locks from sap_summary_locks

MSQSCHEDUL - MS SQL server jobschedules ( as from msdb..sysjobschedules)

MSQSDBABI - INTTAB for Backup Scheduling

MSQSDBAHI - Internal Table for SDBA Results (Logs, Return Codes)

MSQSERTIME - MS SQL server - startup time

MSQSERVER - MS SQL server information

MSQSHCONTG - Displays fragmentation info for data and indexes of a table

MSQSNAP - MS SQL Server: Database performance snapshot

MSQSPHPIDX - MS SQL server - Sp_helpindex structure results

MSQSPMONI - MS SQL server - SP monitor statistics values

MSQSPPARAM - MS SQL server stored procedure parameter structure

MSQSPWHO - MS SQL server on line user status

MSQSQLCODE - MS SQL server structure to get the sp text

MSQSQLRES - MS SQL server - sql command output

MSQSTMTINF - SMS SQL server created stored procedure information

MSQSTPRTXT - MS SQL server - stored procedure text

MSQSYCONFI - MS SQL server configuration options ( as from sysconfigures)

MSQSYSDEV - MS SQL server dump devices (as from sysdevices)

MSQSYSIDX - MS SQL Server: Index Details ( As From Sysindexes )

MSQSYSJOBS - MS SQL server list of jobs ( as from msdb..sysjobs)

MSQTABLST - List of table names.

MSQTABOPT - MS SQL Server - Table

MSQTABSTAT - MS SQL server table statistics

MSQTOPLARG - MS SQL server largest tables in database

MSQTOPMODI - MS SQL server top modified tables in db since last startup

MSQVTLFLS - MS SQL Server Information from ::fn_virtualfilestats

MSQWAITS - MS SQL Server DBCC Wait Statistics

MSQ_DBCNFG - Contains the SQL server parameter values

MSQ_DBDATA - Contains information on a database

MSQ_DYSERV - contains performance measures since sqlserver's last start

MSQ_FILES - Data about operating system files which make up a db

MSQ_JOBS - MS SQL SERVER JOB description (as from msdb..sysjobs)

MSQ_JOBSID - MS SQL Server Job Id

MSQ_LSTAT - SQL Server structure to hold stats on error or agent logs

MSQ_PACCES - Contains data from sysperfinfo on accesses physical&logical

MSQ_PDBMGR - Contains data from the performance object Databases.

MSQ_PERSEC - Data structure to present per second changes in perf data

MSQ_PFCACH - Contains data from the performance object cache manager

MSQ_PLOCKS - Contains data from the performance object lock manager

MSQ_PMEM - Contains data from sysperfinfo on memory

MSQ_PROCES - Data on the processes connected SQL Server

MSQ_STSERV - data about sqlserver and the host its running on

MSQ_VERDAT - structure to return release date of function group smss

Return Table index