PRB: High Column of the Sysdevices Table Used for Dump Devices (75548)
The information in this article applies to:
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
This article was previously published under Q75548 SYMPTOMS
Page 268 of the Microsoft SQL Server "System Administrator's Guide" and
page 504 of the Microsoft SQL Server "Language Reference" state that the
low and high columns in the sysdevices table are not used for dump devices.
However, examining the sysdevices table reveals otherwise for floppy disk
dump devices.
CAUSE
When creating floppy disk dump devices using sp_addumpdevice, the
"media_capacity" parameter is divided by 62K and the result is placed in
the high column in the sysdevices table. For example, if the default size
for disk devices is used, the value 19 is placed in the high column of the
sysdevices table (that is, 1.2 MB divided by 62K). Sp_helpdevice depends on
this value to calculate the size of the floppy disk dump device for the
description column of its output.
Additional query words
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | kbProgramming KB75548 |
|---|
|