标题: 如何查vdevno设备号？ [打印本页] 作者: wangla 时间: 2006-01-11 09:42 标题: 如何查vdevno设备号？ 如何查vdevno设备号？作者: 2BeSybPro 时间: 2006-01-11 10:51
1. sp_helpdevice
2. if the page size is 2k,
select distinct low/16777216 from sysdevices
if the page size is greater than 2k, you need to join sysdevices with spt_values