« Redirect script output to the log | Home | Perl script that e-mails new sites popping up in Yahoo! Search »

Find actual device numbers in Sybase


select low/16777216 "vdevno", name, phyname
from master..sysdevices
where status&2=2
order by 1

Warning! For vdevno>127 it could generate incorrect results.

Topics: Sybase, device | Submitter: checkthis

Comments

You must be logged in to post a comment.