Q4.2: How to remove row affected and dashes
If you pipe the output of isql then you can use sed(1)
to remove this extraneous output:
<![CDATA[
echo "$PASSWD
sp_who
go" | isql -U sa -S MY_SERVER | sed -e '/affected/d' -e '/---/d'
]]>
If you simply wish to eliminate the row affected line use the
set nocount on switch.