ACS Stored Procedures

This small collection of stored procedures allows you to view a few things that you would otherwise have to go to the system tables for. In some cases knowing which columns and tables can be cumbersome so these are provided for you. They are in no way guaranteed.

sp_pwd - display's the current database you are using.
sp_procs - displays an ordered listing of procedures in the current database.
sp_tabs - displays an ordered listing of the tables in the current database.
sp_views - dipslays an ordered listing of the views in the current database.
sp_trigs - displays an ordered listing of triggers in the current database.
sp_seg_used - displays a listing of segments available in the current database. When given a segment name, it will display the objects on that segment and how much space is used by each. (Note that some segment names are reserved words and must be placed in quotes).
sp_ps - displays a listing of all processes on the SQL server. It will also show a listing of objects locked in the current database.

Note that sp_acs_password is not included in this list because it is referenced in another document.

Last Modified September 25, 1996 - Lou Williams