The following is a cron job submitted by

Q Vincent Yin             
umyin@mctrf.mb.ca         

It is quite simple and generates a sp_spaceused report for each
table in your database.  Output is sent to you (any output from
cron is sent to the owner of the cron job.

Cheers
Ed

-------------------------------------------------------------------------------
#!/bin/sh

# Author:	Vincent Yin  umyin@mctrf.mb.ca		Mar 1 1995
# Purpose:	Tabulate the output of sp_spaceused for all the tables in $DB.
#		This script doesn't modify anything.

DB=regdb

PASSWD=

# The $SYBASE env variable
SYBASE=/usr/local/lib/sybase

# The server name as in the interface file
SERVER=

# ...................... no change below this line .............................

export SYBASE

cat <<!
;     sp_spaceused as at `/bin/date` (sorted by data size)
;	   [generated by $0]
;
;name                          rowtotal   reserved    data     index     unused
;
!

$SYBASE/bin/isql -Usa -P$PASSWD -w300 -I$SYBASE/interfaces -S$SERVER <<-! \
    | grep KB     \
    | sort -nr +4 \
    | awk '{printf("%-30s %8s %7s %s %7s %s %6s %s %4s %s \n", $1, $2, $3, $4, $5, $6, $7, $8, $9, $10)}'

	set nocount on
	go
	use $DB
	go
	declare table_cursor cursor
	    for select name from sysobjects where type = 'U'
	    for read only
	go
	declare @table varchar(30)
	open table_cursor
	while 1 = 1
	begin
	    fetch table_cursor into @table
	    if @@sqlstatus != 0 break
	    exec sp_spaceused @table
	end
	deallocate cursor table_cursor
	go
!