System Procedures

SAP^® Adaptive Server^® Enterprise system procedures are similar to the stored procedures that you create using the Transact-SQL^® language, but are supplied in SAP^® ASE to use for updating and getting reports from system tables.

• Permissions on System Procedures
  Set permissions for system procedures in the sybsystemprocs database.
• Auditing System Procedures
  In general, you can audit executed stored procedures by enabling the audit option “exec_procedure”, which generates an audit record containing the name of the stored procedure and the parameters.
• Executing System Procedures
  If a system procedure is executed in a database other than sybsystemprocs, it operates on the system tables in the database in which it was executed.
• Entering Parameter Values
  If a parameter value for a system procedure contains punctuation or embedded blanks, or is a reserved word, you must enclose it in single or double quotes. If the parameter is an object name qualified by a database name or owner name, enclose the entire name in single or double quotes.
• Messages
  System procedures return informational and error messages. System procedure error messages start at error number 17000.
• System Procedure Tables
  Several system procedure tables in the master database, such as spt_values, spt_committab, spt_monitor, and spt_limit_types, are used by system procedures to convert internal system values (for example, status bits) into human-readable format.
• sp_activeroles
  Displays all active roles.
• sp_add_qpgroup
  Adds an abstract plan group.
• sp_add_resource_limit
  Creates a limit on the number of server resources that can be used by an SAP ASE login, or by an application, or both, to execute a query, query batch, or transaction.
• sp_add_time_range
  Adds a named time range to an SAP ASE server.
• sp_addalias
  Allows an SAP ASE user to be known in a database as another user.
• sp_addauditrecord
  Allows users to enter user-defined audit records (comments) into the audit trail.
• sp_addaudittable
  Adds another system audit table after auditing is installed.
• sp_addengine
  Adds an engine to an existing engine group or, if the group does not exist, creates an engine group and adds the engine.
• sp_addexeclass
  Creates or updates a user-defined execution class that you can bind to client applications, logins, and stored procedures.
• sp_addextendedproc
  Creates an extended stored procedure (ESP) in the master database.
• sp_addexternlogin
  (Component Integration Services only) Creates an alternate login account and password to use when communicating with a remote server through Component Integration Services.
• sp_addgroup
  Adds a group to a database. Groups are used as collective names in granting and revoking privileges.
• sp_addlanguage
  Defines the names of the months and days for an alternate language and its date format.
• sp_addlogin
  Deprecated in SAP ASE versions 15.7 and later. To add a login account in SAP ASE, use the create login command.
• sp_addmessage
  Adds user-defined messages to sysusermessages for use by stored procedure print and raiserror calls and by sp_bindmsg.
• sp_addobjectdef
  (Component Integration Services only) Specifies the mapping between a local table and an external storage location.
• sp_addremotelogin
  Authorizes a new remote server user by adding an entry to master.dbo.sysremotelogins.
• sp_addsegment
  Defines a segment on a database device in a database.
• sp_addserver
  Defines a remote server, or the name of the local server; specifies the server for remote procedure calls (RPCs) when using the host and port parameters.
• sp_addthreshold
  Creates a threshold to monitor space on a database segment. When free space on the segment falls below the specified level, the SAP ASE server executes the associated stored procedure.
• sp_addtype
  Creates a user-defined datatype.
• sp_addumpdevice
  Adds a dump device to the SAP ASE server.
• sp_adduser
  Adds a new user to the current database.
• sp_altermessage
  Enables and disables the logging of a system-defined or user-defined message in the SAP ASE error log.
• sp_audit
  Allows a system security officer to configure auditing options.
• sp_autoconnect
  (Component Integration Services only) Defines a passthrough connection to a remote server for a specific user, which allows the named user to enter passthrough mode automatically at login.
• sp_autoformat
  A utility stored procedure that produces readable result set data, sp_autoformat reformats the width of variable-length character data to display only non-blank characters. Trailing blanks are truncated in the output.
• sp_bindcache
  Binds a database, table, index, text object, or image object to a data cache.
• sp_bindefault
  Binds a user-defined default to a column or user-defined datatype.
• sp_bindexeclass
  Associates an execution class with a client application, login, stored procedure, or default execution class.
• sp_bindmsg
  Binds a user message to a referential integrity constraint or check constraint.
• sp_bindrule
  Binds a rule to a column or user-defined datatype.
• sp_cacheconfig
  Creates, configures, reconfigures, and drops data caches, and provides information about them.
• sp_cachestrategy
  Enables or disables prefetching (large I/O) and MRU cache replacement strategy for a table, index, text object, or image object.
• sp_changedbowner
  Changes the owner of a user database.
• sp_changegroup
  Changes a user’s group.
• sp_checknames
  Checks the current database for names that contain characters not in the 7-bit ASCII set.
• sp_checkreswords
  Detects and displays identifiers that are Transact-SQL reserved words. Checks server names, device names, database names, segment names, user-defined datatypes, object names, column names, user names, login names, and remote login names.
• sp_checksource
  Checks for the existence of the source text of compiled objects such as views, defaults, rules, triggers, procedures, declarative defaults, check constraints, computed columns, function-based indexes and predicates. The predicate name may be a user-defined or internal name.
• sp_chgattribute
  Changes the max_rows_per_page, fillfactor, reservepagegap, or exp_row_size value for future space allocations of a table or an index; sets the concurrency_opt_threshold for a table. Provides the user interface for optimistic index locking.
• sp_cleanpwdchecks
  sp_cleanpwdchecks is a custom stored procedure that allows you to define when and how to remove login and password-related attributes stored in user-defined tables.
• sp_clearpsexe
  Clears the execution attributes of an SAP ASE session that was set by sp_setpsexe.
• sp_clearstats
  Initiates a new accounting period for all server users or for a specified user. Prints statistics for the previous period by executing sp_reportstats.
• sp_client_addr
  Displays the IP (Internet Protocol) address of every SAP ASE task with an attached client application, including the spid and the client host name.
• sp_cluster
  (Cluster environments only) Performs a number of procedures related to clusters.
• sp_clusterlockusage
  (Cluster environments only) Reports on the free, used, and retained locks in the cluster .
• sp_cmp_all_qplans
  Compares all abstract plans in two abstract plan groups.
• sp_cmp_qplans
  Compares two abstract plans.
• sp_commonkey
  Defines a common key—columns that are frequently joined—between two tables or views.
• sp_companion
  Performs cluster operations such as configuring SAP ASE as a secondary companion in a high availability system and moving a companion server from one failover mode to another. sp_companion is run from the secondary companion.
• sp_compatmode
  Verifies whether full compatibility mode can be used.
• sp_config_dump
  Allows you to list, add, or change dump configurations.
• sp_confighistory
  Creates the ch_events view and displays changes made to SAP ASE configuration.
• sp_configure
  Displays configuration parameters by group, their current values, their non-default value settings, the value to which they have most recently been set, and the amount of memory used by this setting. Displays only the parameters with a display level that is the same as or below that of the user.
• sp_copy_all_qplans
  Copies all plans for one abstract plan group to another group.
• sp_copy_qplan
  Copies one abstract plan to an abstract plan group.
• sp_countmetadata
  Displays the number of indexes, objects, or databases in the SAP ASE server.
• sp_cursorinfo
  Reports information about a specific cursor or all execute cursors that are active for your session.
• sp_dbextend
  Allows you to:
• sp_dboption
  Displays or changes database options, and enables the asynchronous log service feature.
• sp_dbrecovery_order
  Specifies the order in which user databases are recovered and lists the user-defined recovery order of a database or all databases.
• sp_dbremap
  Forces the SAP ASE server to recognize changes made by alter database. Run this procedure only when instructed to do so by an SAP ASE message.
• sp_defaultloc
  (Component Integration Services only) Defines a default storage location for objects in a local database.
• sp_deletesmobj
  (Only when the TSM is licensed at your site) Deletes specified backup objects from the IBM Tivoli Storage Manager (TSM).
• sp_depends
  Displays information about database object dependencies—the views, triggers, user-defined functions, procedures, and predicates—in the database that depend on a specified table or view, the tables and views in the database on which the specified view, trigger, procedure, or predicate depends, and multiple triggers associated with a table. Predicates cannot be granted in a view.
• sp_deviceattr
  (UNIX platforms only) Changes the device parameter settings of an existing database device file.
• sp_diskdefault
  Specifies whether or not a database device can be used for database storage if the user does not specify a database device or specifies default with the create database or alter database commands.
• sp_displayaudit
  Displays the status of audit options.
• sp_displaylevel
  Sets or shows which SAP ASE configuration parameters appear in sp_configure output.
• sp_displaylogin
  Displays information about a login account. By using a wildcard expression (%), you can also obtain information about matching logins. Also displays the encryption versions of the login password stored on disk.
• sp_displayroles
  Displays all roles granted to another role, login or login profile, the entire hierarchy tree of roles in table format, and other login security-related parameters configured for the specified role, including the date when the role was locked, its reason, and the login server user ID (suid) that locked the role. For password-protected roles, also displays the role password encryption version.
• sp_downgrade
  (master database only) Validates readiness for downgrade to a version of SAP ASE earlier than the current version you are running. Also downgrades the system catalog changes that were modified with the current version of SAP ASE.
• sp_dropalias
  Removes the alias user name identity established with sp_addalias.
• sp_drop_all_qplans
  Deletes all abstract plans in an abstract plan group.
• sp_drop_qpgroup
  Drops an abstract plan group.
• sp_drop_qplan
  Drops an abstract plan.
• sp_drop_resource_limit
  Removes one or more resource limits from the SAP ASE server.
• sp_drop_time_range
  Removes a user-defined time range from the SAP ASE server.
• sp_dropdevice
  Drops an SAP ASE database device or dump device.
• sp_dropengine
  Drops an engine from a specified engine group or, if the engine is the last one in the group, drops the engine group.
• sp_dropexeclass
  Drops a user-defined execution class.
• sp_dropextendedproc
  Removes an extended stored procedure.
• sp_dropexternlogin
  (Component Integration Services only) Drops the definition of a remote login previously defined by sp_addexternlogin.
• sp_dropglockpromote
  Removes lock promotion values from a table or database.
• sp_ dropglockpromote_ptn
  Removes partition lock promotion values.
• sp_dropgroup
  Drops a group from a database.
• sp_dropkey
  Removes from the syskeys table a key that had been defined using sp_primarykey, sp_foreignkey, or sp_commonkey.
• sp_droplanguage
  Drops an alternate language from the server and removes its row from master.dbo.syslanguages.
• sp_droplogin
  Deprecated by SAP ASE 15.7. To drop a login account in SAP ASE, use the drop login command. See Reference Manual: Commands.
• sp_dropmessage
  Drops user-defined messages from sysusermessages.
• sp_dropobjectdef
  (Component Integration Services only) Deletes the external storage mapping provided for a local object.
• sp_dropremotelogin
  Drops a remote user login.
• sp_droprowlockpromote
  Removes row lock promotion threshold values from a database or table.
• sp_droprowlockpromote_ptn
  Removes partition lock promotion threshold values at server, database, or table levels.
• sp_dropsegment
  Drops a segment from a database or unmaps a segment from a particular database device.
• sp_dropserver
  Drops a server from the list of known servers or drops remote logins and external logins in the same operation.
• sp_dropthreshold
  Removes a free-space threshold from a segment.
• sp_droptype
  Drops a user-defined datatype.
• sp_dropuser
  Drops a user from the current database.
• sp_dump_history
  Allows you to purge records from the dump history file.
• sp_dump_info
  The sp_dump_info system procedure displays the size of data and log that an uncompressed cumulative dump would contain at a specific point in time.
• sp_dumpoptimize
  Specifies the amount of data dumped by Backup Server during a dump database operation.
• sp_encryption
  Reports encryption information.
• sp_engine
  Enables you to bring an engine online or offline. In threaded mode, use alter thread pool to bring engines online.
• sp_errorlog
  Dynamically changes the path of the error log.
• sp_estspace
  Estimates the amount of space required for a table and its indexes, and the time needed to create the index.
• sp_export_qpgroup
  Exports all plans for a specified user and abstract plan group to a user table.
• sp_extendsegment
  Extends the range of a segment to another database device.
• sp_extengine
  (Only when you have a valid SAP ASE EJB Server site license at your site) Starts and stops EJB Server. Displays status information about EJB Server.
• sp_extrapwdchecks
  A custom stored procedure that can contain user-defined logic for password complexity checks. You can configure sp_extrapwdchecks according to your security needs. Install sp_extrapwdchecks in the master database.
• sp_familylock
  Reports information about all the locks held by a family (coordinating process and its worker processes) executing a statement in parallel.
• sp_find_qplan
  Finds an abstract plan, given a pattern from the query text or plan text.
• sp_fixindex
  sp_fixindex repairs corrupt indexes on system tables. It can rebuild a specified index or all indexes on the table. sp_fixindex rebuilds the data layer if the target table has a placement or clustered index (it reclaims the unused space in the data layer while working on the placement or clustered index of a system table).
• sp_flushstats
  Flushes statistics from in-memory storage to the systabstats and sysstatistics system tables.
• sp_forceonline_db
  Provides access to all the pages in a database that were previously marked suspect by recovery.
• sp_forceonline_object
  Provides access to an index previously marked suspect by recovery.
• sp_forceonline_page
  Provides access to pages previously marked suspect by recovery.
• sp_foreignkey
  Defines a foreign key on a table or view in the current database.
• sp_freedll
  Unloads a dynamic link library (DLL) that was previously loaded into XP Server memory to support the execution of an extended stored procedure (ESP).
• sp_getmessage
  Retrieves stored message strings from sysmessages and sysusermessages for print and raiserror statements.
• sp_grantlogin
  (Windows only) Assigns SAP ASE roles or default permissions to Windows users and groups when Integrated Security mode or Mixed mode (with Named Pipes) is active.
• sp_ha_admin
  Performs administrative tasks on SAP ASE servers configured with Failover in a high availability system. sp_ha_admin is installed with the installhavss script on UNIX platforms or the insthasv script on Windows.
• sp_help
  Reports information about a database object (any object listed in sysobjects) and about system or user-defined datatypes, as well as user-defined functions, computed columns and function-based indexes. Column displays optimistic_index_lock.
• sp_help_resource_limit
  Reports on resource limits.
• sp_help_qpgroup
  Reports information on an abstract plan group.
• sp_help_qplan
  Reports information about an abstract plan.
• sp_helpapptrace
  Determines which sessions the SAP ASE server is tracing. Returns the server process IDs (spids) for all the sessions the SAP ASE server is tracing, the spids of the sessions tracing them, and the name of the tracefile.
• sp_helpartition
  Lists partition-related information of a table or index.
• sp_helpcache
  Displays information about the objects that are bound to a data cache or the amount of overhead required for a specified cache size.
• sp_helpcomputedcolumn
  Reports information on the computed columns in a specified table.
• sp_helpconfig
  Reports help information on configuration parameters.
• sp_helpconstraint
  Reports information about integrity constraints used in the specified tables.
• sp_helpdb
  Reports information about a particular database or about all databases.
• sp_helpdefrag
  sp_helpdefrag reports defragmentation information for either all eligible objects for reorg defrag in the database whose context it is invoked from or for the given object if it is eligible for reorg defrag.
• sp_helpdevice
  Reports information about a particular device or about all SAP ASE database devices and dump devices.
• sp_helpextendedproc
  Displays extended stored procedures (ESPs) in the current database, along with their associated DLL files.
• sp_helpexternlogin
  (Component Integration Services only) Reports information about external login names.
• sp_helpgroup
  Reports information about a particular group or about all groups in the current database.
• sp_helpindex
  Reports information about the indexes created on a table. Reports information on computed column indexes and function-based indexes.
• sp_helpjava
  Displays information about Java classes and associated JARs that are installed in the database.
• sp_helpjoins
  Lists the columns in two tables or views that are likely join candidates.
• sp_helpkey
  Reports information about a primary, foreign, or common key of a particular table or view, or about all keys in the current database.
• sp_helplanguage
  Reports information about a particular alternate language or about all languages.
• sp_helplog
  Reports the name of the device that contains the first page of the transaction log.
• sp_helpmaplogin
  Displays mapping information.
• sp_helpobjectdef
  (Component Integration Services only) Reports owners, objects, and type information for remote object definitions.
• sp_helpremotelogin
  Reports information about a particular remote server’s logins or about all remote server logins.
• sp_helprotect
  Reports on permissions for database objects, users, groups, or roles.
• sp_helpsegment
  Reports information about a particular segment or about all segments in the current database.
• sp_helpserver
  Reports information about a particular remote server or about all remote servers.
• sp_helpsort
  Displays the SAP ASE server’s default sort order and character set.
• sp_helptext
  Displays the source text of a compiled object, as well as the text for user-defined functions, computed columns, or function-based index definitions.
• sp_helpthread
  Displays the current thread pool configuration.
• sp_helpthreshold
  Reports the segment, free-space value, status, and stored procedure associated with all thresholds in the current database or all thresholds for a particular segment.
• sp_helptrigger
  sp_helptrigger lists all triggers created on the table specified by tablename; which command (insert, update, or delete) fires the trigger, and the trigger's order number.
• sp_helpuser
  Reports information about a particular user, group, or alias, or about all users, in the current database. Also identifies objects and user-defined datatypes owned by a users.
• sp_hidetext
  Hides the source text for the specified compiled object, as well as the text of computed columns, predicates, and function-based index keys. sp_hidetext also encrypts the text for user-defined functions.
• sp_import_qpgroup
  Imports abstract plans from a user table into an abstract plan group.
• sp_indsuspect
  Checks user tables for indexes marked as suspect during recovery following a sort order change.
• sp_jreconfig
  Manages the Java PCA/JVM. Enables or disables arguments and directives, changes configuration values, and reports configuration values.
• sp_ldapadmin
  Creates or lists an LDAP URL search string, verifies an LDAP URL search string or login, or specifies the access accounts and tunable LDAPUA-related parameters.
• sp_listener
  Dynamically starts and stops SAP ASE listeners on any given port on a per-server basis.
• sp_listsuspect_db
  Lists all databases that currently have offline pages because of corruption detected on recovery, including the database name, number of suspect pages, and number of objects containing suspect pages.
• sp_listsuspect_object
  Lists all indexes in a database that are currently offline because of corruption detected on recovery.
• sp_listsuspect_page
  Lists all pages in a database that are currently offline because of corruption detected on recovery, including the database name, page ID, object, index ID, and access status for every suspect page in the specified database or, if dbname is omitted, in the current user database.
• sp_lmconfig
  Configures license management-related information on SAP ASE.
• sp_lock
  Reports the object names and IDs of processes that currently hold locks.
• sp_locklogin
  Locks an SAP ASE account so that the user cannot log in, or displays a list of all locked accounts.
• sp_logdevice
  Moves the transaction log of a database with log and data on the same device to a separate database device.
• sp_logging_rate
  Calculates the transaction log growth rate for the specified time period
• sp_loginconfig
  (Windows only) Displays the value of one or all integrated security parameters.
• sp_logininfo
  (Windows only) Displays all roles granted to Windows users and groups with sp_grantlogin.
• sp_logiosize
  Changes the log I/O size used by the SAP ASE server to a different memory pool when doing I/O for the transaction log of the current database.
• sp_logintrigger
  Sets and displays the global login trigger. This global login trigger has the same characteristics as a personal login script. It is executed before any personal login script for every user that tries to log in, including system administrators and security officers.
• sp_maplogin
  Maps external users to SAP ASE logins.
• sp_merge_dup_inline_default
  Removes existing duplicate inline default objects, converting the unique inline defaults to sharable inline default objects.
• sp_metrics
  Backs up, drops, and flushes QP metrics—always captured in the default running group, which is group 1 in each respective database—and their statistics on queries.
• sp_modify_resource_limit
  Changes a resource limit by specifying a new limit value, or the action to take when the limit is exceeded, or both.
• sp_modify_time_range
  Changes the start day, start time, end day, and end time associated with a named time range.
• sp_modifylogin
  Deprecated by SAP ASE version 15.7 and later. To modify a login account in SAP ASE, use the alter login command. See Reference Manual: Commands.
• sp_modifystats
  Allows the system administrator, or any user with permission to execute the procedure and update statistics on the target table, to modify the density values of columns in sysstatistics.
• sp_modifythreshold
  Modifies a threshold by associating it with a different threshold procedure, free-space level, or segment name.
• sp_monitor
  Displays statistics about the SAP ASE server.
• sp_monitorconfig
  Displays cache usage statistics regarding metadata descriptors for indexes, objects, databases, and the kernel resource memory pool. sp_monitorconfig also reports statistics on auxiliary scan descriptors used for referential integrity queries, and usage statistics for transaction descriptors and DTX participants.
• sp_monitor_server
  Provides server-wide monitoring information.
• sp_object_stats
  Shows lock contention, lock wait-time, and deadlock statistics for tables and indexes.
• sp_objectsegment
  Reports the partition name, segment name, and creation date for the specified object.
• sp_opt_querystats
  Returns a performance analysis for the selected query.
• sp_optgoal
  Creates a user-defined optimization goal, and defines the set of active criteria included in the goal.
• sp_options
  Shows option values.
• sp_passthru
  (Component Integration Services only) Allows the user to pass a SQL command buffer to a remote server.
• sp_password
  Deprecated in SAP ASE version 15.7 and later. To add or change a password for a login account in SAP ASE, use the create login and alter login commands. See Reference Manual: Commands.
• sp_passwordpolicy
  Allows a user with sso_role to configure login and password policy options.
• sp_pciconfig
  Manages the Java PCI Bridge. Enables or disables arguments and directives, changes configuration values, and reports configuration values.
• sp_placeobject
  Puts future space allocations for a table or index on a particular segment.
• sp_plan_dbccdb
  Recommends suitable sizes for new dbccdb and dbccalt databases, lists suitable devices for dbccdb and dbccalt, and suggests a cache size and a suitable number of worker processes for the target database.
• sp_poolconfig
  Creates, drops, resizes, and provides information about memory pools within data caches.
• sp_post_xpload
  Checks and rebuilds indexes after a cross-platform load database where the endian types are different.
• sp_primarykey
  Defines a primary key on a table or view.
• sp_processmail
  (Windows only) Reads, processes, sends, and deletes messages in the SAP ASE message inbox, using the xp_findnextmsg, xp_readmail, xp_sendmail, and xp_deletemail system extended stored procedures (ESPs).
• sp_procxmode
  Displays or changes the execution modes associated with stored procedures.
• sp_querysmobj
  (Only when the TSM is licensed at your site) Queries the Tivoli Storage Manager (TSM) for a list of the SAP ASE backup objects.
• sp_recompile
  Causes each stored procedure and trigger that uses the named table to be recompiled the next time it runs.
• sp_refit_admin
  (Cluster environments only) Provides an interface to perform various disk refit-related actions, such as showing the current status of the disk refit process, resetting the state of the disk refit process, skipping the disk refit process for an instance, and so on.
• sp_remoteoption
  Displays or changes remote login options.
• sp_remotesql
  (Component Integration Services only) Establishes a connection to a remote server, passes a query buffer to the remote server from the client, and relays the results back to the client.
• sp_rename
  Changes the name of a user-created object or user-defined datatype in the current database.
• sp_rename_qpgroup
  Renames an abstract plan group.
• sp_renamedb
  Changes the name of a user database.
• sp_reportstats
  Reports statistics on system usage.
• sp_restore_system_role
  Restores the system defined role or database owner to the default role privilege configuration.
• sp_revokelogin
  (Windows only) Revokes SAP ASE roles and default permissions from Windows users and groups when Integrated Security mode or Mixed mode (with Named Pipes) is active.
• sp_role
  This system procedure is deprecated by SAP ASE 15.7 and higher. To grant or revoke roles, use the greant role or revoke role commands.
• sp_securityprofile
  Lists the attributes or bindings associated with a login profile.
• sp_sendmsg
  (UNIX only) Sends a message to a User Datagram Protocol (UDP) port.
• sp_serveroption
  Displays or changes remote server options.
• sp_set_qplan
  Changes the text of the abstract plan of an existing plan without changing the associated query.
• sp_setlangalias
  Assigns or changes the alias for an alternate language.
• sp_setpglockpromote
  Sets or changes the lock promotion thresholds for a database, for a table, or for the SAP ASE server.
• sp_setpglockpromote_ptn
  Sets partition-lock promotion thresholds at the server, database, and table level.
• sp_setpsexe
  Sets custom execution attributes for a session while the session is active.
• sp_setrowlockpromote
  Sets or changes row-lock promotion thresholds for a datarows-locked table, for all datarows-locked tables in a database, or for all datarows-locked tables on a server.
• sp_setrowlockpromote_ptn
  Sets partition-lock promotion thresholds at the server, database, and table level.
• sp_setsuspect_granularity
  Displays or sets the recovery fault isolation mode for a user database, which governs how recovery behaves when it detects data corruption.
• sp_setsuspect_threshold
  Displays or sets the maximum number of suspect pages that the SAP ASE server allows in a database before marking the entire database suspect.
• sp_setup_table_transfer
  Run once in each database containing the tables marked for incremental transfer to create the spt_TableTransfer table in this database.
• sp_shmdumpconfig
  Specifies the dump condition of a shared memory dump, and displays current settings. You must enable the dump on conditions configuration parameter to perform shared memory dumps.
• sp_show_options
  Prints all the server options that have been set in the current session.
• sp_showcontrolinfo
  Displays information about thread pool assignments, bound client applications, logins, and stored procedures.
• sp_showexeclass
  Displays the execution class attributes and the thread pool name associated with the specified execution class.
• sp_showoptstats
  Similar in function to the optdiag standalone utility in an XML document but in a system procedure format, sp_showoptstats extracts and displays statistics and histograms for various data objects from system tables such as systabstats and sysstatistics.
• sp_showplan
  Displays the showplan output for any user connection for the current SQL statement or for a previous statement in the same batch.
• sp_showpsexe
  Displays execution class, current priority, and thread pool affinity for all client sessions running on the SAP ASE server.
• sp_spaceusage
  Reports the space usage for a table, index, or transaction log and estimates the amount of fragmentation for tables and indexes in a database. The estimates are computed using an average row-length for data and index rows, and the number of rows in a table. You can archive the space usage and fragmentation data for future reporting and trends analysis. sp_spaceusage supports a number of actions, including help, display, archive and report, to indicate the current SAP ASE space usage.
• sp_spaceused
  Displays estimates of the number of rows, the number of data pages, the size of indexes, and the space used by a specified table or by all tables in the current database.
• sp_ssladmin
  Adds, deletes, or displays a list of server certificates for the SAP ASE server.
• sp_syntax
  Displays the syntax of Transact-SQL statements, system procedures, utilities, and other routines for the SAP ASE server, depending on which products and corresponding sp_syntax scripts exist on your server.
• sp_sysmon
  Displays performance information.
• sp_tab_suspectptn
  Lists tables with suspect partitions. A range-partitioned table on character-based partition keys can become suspect after a sort-order change, and hash-partitioned tables can become suspect after a cross-platform dump load.
• sp_tempdb
  sp_tempdb allows users to:
• sp_tempdb_markdrop
  (Cluster Edition) Places a local system temporary database in the drop state.
• sp_thresholdaction
  Executes automatically when the number of free pages on the log segment falls below the last-chance threshold, unless the threshold is associated with a different procedure. SAP does not provide this procedure.
• sp_tran_dumpable_status
  If you cannot make a transaction dump on a database, sp_tran_dumpable_status displays the reasons the dump is not possible.
• sp_transactions
  Reports information about active transactions.
• sp_unbindcache
  Unbinds a database, table, index, text object, or image object from a data cache.
• sp_unbindcache_all
  Unbinds all objects that are bound to a cache.
• sp_unbindefault
  Unbinds a created default value from a column or from a user-defined datatype.
• sp_unbindexeclass
  Removes the execution class attribute previously associated with an client application, login, stored procedure, or default execution class for the specified scope.
• sp_unbindmsg
  Unbinds a user-defined message from a constraint.
• sp_unbindrule
  Unbinds a rule from a column or from a user-defined datatype.
• sp_version
  Returns the version information of the installation scripts (installmaster, installdbccdb, and so on) that was last run and whether it was successful.
• sp_volchanged
  Notifies the Backup Server that the operator performed the requested volume handling during a dump or load.
• sp_webservices
  Creates and manages the proxy tables used in the SAP ASE Web Services Engine.
• sp_who
  Reports information about all current SAP ASE users and processes or about a particular user or process. Includes the thread_pool column, which describes the thread pool the SAP ASE server uses to execute a task.
• sp_xact_loginfo
  sp_xact_loginfo provides the span of oldest active transaction in terms of percentage of total log space.
• sp_xmlschema
  Creates and maintains the spt_xmlcatalog user table in the SAP ASE database. spt_xmlcatalog stores schema definitions that the xmlvalidate function uses to validate XML documents