Transact-SQL User's Guide

Home

Getting information about stored procedures

Transact-SQL User's Guide

Chapter 14 Using Stored Procedures

System procedures

Other Sybase-supplied procedures

Sybase provides catalog stored procedures, system extended stored procedures (system ESPs) and dbcc procedures.

Catalog stored procedures

Catalog stored procedures are system procedures which retrieve information from the system tables in tabular form. The catalog stored procedures are:

sp_column_privileges	sp_pkeys	sp_stored_procedures
sp_columns	sp_server_info	sp_table_privileges
sp_databases	sp_special_columns	sp_tables
sp_datatype_info	sp_sproc_columns
sp_fkeys	sp_statistics

System extended stored procedures

Extended stored procedures (ESPs) call procedural language functions from Adaptive Server. The system extended stored procedures, created by installmaster at installation, are located in the sybsystemprocs database and are owned by the System Administrator. They can be run from any database and their names begin with "xp_". The system extended stored procedures are:

xp_cmdshell	xp_findnextmsg	xp_sendmai
xp_deletemail	xp_logevent	xp_startmai
xp_enumgroups	xp_readmail	xp_stopmai

See Chapter 15, "Using Extended Stored Procedures," for more information on creating and using ESPs.

dbcc procedures

The dbcc procedures, created by installdbccdb, are stored procedures for generating reports on information created by dbcc checkstorage. These procedures reside in the dbccdb database or in the alternate database, dbccalt. The dbcc procedures are:

sp_dbcc_alterws	sp_dbcc_differentialreport	sp_dbcc_statisticsreport
sp_dbcc_configreport	sp_dbcc_evaluatedb	sp_dbcc_summaryreport
sp_dbcc_createws	sp_dbcc_faultreport	sp_dbcc_updateconfig
sp_dbcc_deletedb	sp_dbcc_fullreport
sp_dbcc_deletehistory	sp_dbcc_runcheck


	Expand Search