The following example queries sysdatabases and takes each database name and creates a string of the sort sp_helpdb dbname and sends the results to another isql. This is accomplished using bourne shell sh(1) and sed(1) to strip unwanted output:

#!/bin/sh

PASSWD=yuk

DSQUERY=GNARLY_HAIRBALL

echo "$PASSWD print "$PASSWD"

go

select 'sp_helpdb ' + name + char(10) + 'go'

from sysdatabases

go" | isql -U sa -S $DSQUERY -w 1000 |

sed -e '/affected/d' -e '/---/d' -e '/Password:/d' |

isql -U sa -S $DSQUERY -w 1000