select low/16777216 "vdevno", name, phyname
from master..sysdevices
where status&=2
order by 1
from master..sysdevices
where status&=2
order by 1
Warning! For vdevno>127 it could generate incorrect results.
Find actual device numbers in Sybaseselect low/16777216 "vdevno", name, phyname from master..sysdevices where status&=2 order by 1 Warning! For vdevno>127 it could generate incorrect results. |
Leave a Reply