Special thanx to Peter Theobald for allowing me access to LI Net
to post these procedures.  Additional thanx to Kemal Singh.  These
procedures were wholely written by Edward Barlow and Jim Bain and
are copyright (c) 1995.  Use them in good health!

Ed Barlow
July 4 1995

ebar...@pipeline.com
-------------------------
EXTENDED SYBASE STORED PROCEDURES V1.2
Copyright (c) 1995 By Edward Barlow
======================================

Enclosed are an extended set of Sybase stored procedures. These
procedures both provide additional functionality and provide new
ways to look at the data provided by Sybase in their System Tables.
They also provide many new formats that allows users, developers,
and administrators to see the data they want in the format they want.

NOTE: THESE PROCEDURES HAVE ONLY BEEN TESTED UNDER 4.9.X (and 4.8 and 4.2).
I do not have access to system 10 and will test them in the future under
that release.  As they rely heavily on catalog tables, some of the procs
may not work under 10.  

The library is released as a set of uuencoded files.  'cat' the files
together and pipe them through uudecode to reveal a tar file.  untar that
file and follow instructions in the readme file (this file).

These procedures reside in the master database (in Sybase 4.9.2) and
eventually should move to the sybsystemprocs database. All procedure
names start with "sp__". This naming convention ensures that the
procedures, when run, will be available from any database and that,
when they are run, the database context will be the current database.
Thus, if you are in the statsdb database, you can get the space used in
statsdb by running sp__dbspace.

I am very interested in any thoughts about how to expand these
procedures.  Please send me any comments and suggestions (currently
ebar...@pipeline.com).

Full documentation is included in the file man.doc.  This is a microsoft
word 2.0 document.  There is also a file man.txt which is the documentation
in text format.  The text document might be hard to read due to line breaks
but I dont feel like cleaning it up - that might be an arduous task.  
Either print it in 132 column mode or Download the .doc file to your pc
and import into any other word processor - they can all handle ms word
2.0 format.

USAGE INFORMATION
=================
I am releasing this library as freeware.  I ask that you try the software and
register if you like it.  Redistribute at will.  Tell your friends.  Give me
access to procedures that you have written for future versions.  Tell me
about bugs.  Be nice - i am making no money off this.

In fact, I no longer use many of the system provided procedures  - these
are much better.  If you register I will provide you with free bug fixes and
will put you on my mailing list for other software tools that I release.  There
is some good stuff in development.

Other software nearing completion: Capacity monitoring utility (prints
historical graphs of server utilization), Reverse Engineering Utility
(both for ddl and for server configuration), Server monitor, Server
reporting tool, and Integrated Backup Facility.

INSTALLATION
============
To install these procedures, run the command configure.
This command can be run with no parameters (whereapon it will ask for
a server and sa password) "configure" or it can be run using the syntax
"configure <SERVER> <SA_PASSWORD>". As the master database will be
modified by these procedures, it is suggested that you dump that
database before AND after you load the procedures. The script for
each procedure will issue a "dump tran master with truncate_only"
prior to the addition of the procedure so that master log space (which
is generally small) will not be filled.

UNINSTALL
=========
SQL statements to uninstall this package are contained in the file cleanup.SQL.

DOCUMENTATION
=============
I think this package is pretty complete and should be usable.  The bottom of
this file contains an summary documentation of what procedures are included
with this package.  I have also attached a full manual in the file man.doc,
which is in microsoft word 2.0 format.  An ascii version is in man.txt, but I
make no guarantees about readibility.  

WARANTY
=======
This software is provided as-is. No warranties or guarantees
are made. To the best of my knowledge, any bugs or outstanding issues
are documented at the end of this document and in the file "BUGS" that
comes with the source code. Please read the file README for any last
minute changes to the software. Please notify me of any things that can
be done to make this a better package.  

RESALE AND COPYRIGHT
====================
This software is provided as shareware. Share it in
good health. You are allowed to use this software so long as all copyright
notices and the README file are not altered and so long as no money is made
by the sale of this software (i.e. you cant include it in a commercial
package without permission). If you would like to "make money" or include
the code in a commercial package, I ask that you decide on a "fair" price
and create some form of "fair" agreeement. Make two copies, sign them both,
and send them to the author (Edward Barlow). If the agreement seems fair,
I will sign both and send one copy back to you, and we will have a deal.  
I have put significant effort into this code and, while my primary purpose
is to create software for people to use, I expect a fair shake from anybody
who can profit from my endeavors.

ONE CHEAP PLUG
==============
I do unix & sybase consulting work in the New York Area.  Get in touch if
you think I might be of assistance. I am developing some nice commercial
software that can be used for security and business audits and another really
nice package that can be used for automating system administration. My home
phone is 212 366 1137 - but I ask that you not use it except regarding
consulting stuff.  Use ebar...@pipeline.com instead.

FINAL NOTE
==========
All procedures in this package are copyright (c) 1994-5 by
Edward Barlow. Special thanks to Jim Bain, who authored many of them
and who greatly assisted in this project.  

Edward Barlow
ebar...@pipeline.com
45 5th Ave #12A
New York, NY 10003

========================================================

MODIFIED SYBASE PROCEDURES
sp__help                                Better sp_help
sp__helpdb                      Database Information
sp__helpdevice          Break down database devices into a nice report
sp__helpgroup           List groups in database by access level
sp__helpindex           Shows indexes by table
sp__helpsegment Segment Information
sp__helpuser            Lists users in current database by group (include aliases)
sp__lock                                Lock information
sp__who                         sp_who that fits on a page

AUDIT PROCEDURES
sp__auditsecurity       Security Audit On Server
sp__auditdb                     Audit Current Database For Potential Problems

SYSTEM ADMINISTRATOR PROCEDURES
sp__block                       Blocking processes.
sp__dbspace                     Summary of current database space information.
sp__dumpdevice          Listing of Dump devices
sp__helpdbdev           Show how Databases use Devices
sp__helplogin           Show logins and remote logins to server
sp__helpmirror          Shows mirror information, discover broken mirrors
sp__segment                     Segment Information
sp__server                      Server summary report (very useful)
sp__vdevno                      Who's who in the device world

DBA PROCEDURES
sp__badindex       give information about bad indexes (nulls, bad statistics...)
sp__collist                     list all columns in database
sp__indexspace          Space used by indexes in database
sp__noindex                     list of tables without indexes.
sp__helpcolumns show columns for given table
sp__helpdefault list defaults (part of objectlist)
sp__helpobject          list objects
sp__helpproc            list procs (part of objectlist)
sp__helprule            list rules (part of objectlist)
sp__helptable           list tables (part of objectlist)
sp__helptrigger         list triggers (part of objectlist)
sp__helpview            list views  (part of objectlist)
sp__trigger                     Useful synopsis report of current database trigger schema

REVERSE ENGINEERING
sp__revalias            get alias script for current db
sp__revdb                       get db creation script for server
sp__revdevice           get device creation script
sp__revgroup            get group script for current db
sp__revindex            get indexes script for current db
sp__revlogin            get logins script for server
sp__revmirror           get mirroring script for server
sp__revuser                     get user script for current db

OTHER PROCEDURES
sp__bcp                         Create unix script to bcp in/out database
sp__date                                Who can remember all the date styles?
sp__quick_stats Quick dump of server summary information